Find Jobs
Hire Freelancers

for maria and raz

$10-20 USD

Completed
Posted almost 6 years ago

$10-20 USD

Paid on delivery
(20 pts.) Do Capstone Exercise on page 199. Be sure to use Move Chart to move charts to their own chart sheets where directed, do not use Copy/Paste. (20 pts.) Create a workbook named census_LastNameFirstName to display charts for some census data for five areas (ex. states, countries, counties) for two different years. Your worksheet should satisfy the following specifications. Your workbook must be unique and reflect your own data and design. In cell A1 display your name merged and centered across used columns. Increase the font size and add a different font name than the default font. In cell A2 use the Insert Link command to cite the source of your data. Paste the URL into the Address area. Include row and column headings as appropriate for the area and time units. Create a Clustered 2-D Bar chart chart plotting data for all the areas and time units such that there are five data series, one for each area. Edit the fill color of the series with the smallest bar to black. Add data labels to the end of the smallest series showing the numeric value. Use the Insert Shape command to add a shape containing text with a meaningful fact about this series. Insert an arrow shape to point to the smallest series. Include a chart title and move the legend to the left side with a legend command. Use the Move Chart to move the chart to its own sheet named Bar. Create a Line chart with Markers comparing values for one time unit across the five. Format the markers to a diamond shape with an enlarged size. Add major vertical gridlines. Add a Y axis title. Add a data table which appears under the chart. Use the Move Chart to move the chart to its own sheet named Line. Give an appropriate name to the data sheet and move it to the left of the three sheets. Add a header of your name in the left side, sheet name in the middle, and current date on the right side.
Project ID: 16616260

About the project

5 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Here is the bid as we've agreed. It will be delivered within 2 hours, tops. Just writing here to have 100 characters.
$20 USD in 0 day
5.0 (11 reviews)
3.2
3.2
5 freelancers are bidding on average $21 USD for this job
User Avatar
Hello.....! I'm interested,I'll complete the project a little budget and your full satisfaction. lets give me message so that we can discuss about the project details.. I'm waiting for your response....
$25 USD in 0 day
4.7 (12 reviews)
4.0
4.0

About the client

Flag of UNITED STATES
Bath, United States
5.0
1
Member since Mar 9, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.