In this project, you will analyze U.S. population growth over the last 40 years.
Skills needed to complete this project:
- Applying Quick Styles and Other Formatting to Sparklines (Skill 7.16)
- Changing the Sparkline Type (Skill 7.14)
- Adding Markers to Sparklines (Skill 7.15)
- Adding a Data Series to a Chart (Skill 7.5)
- Creating a Combination Chart (Skill 7.1)
- Formatting Other Chart Elements (Skill 7.8)
- Formatting a Data Point or a Data Series (Skill 7.6)
- Applying a Chart Template (Skill 7.10)
- Inserting a Shape (Skill 7.21)
- Applying Quick Styles and Other Formatting to Shapes (Skill 7.22)
- Creating a Chart Template (Skill 7.9)
- Adding and Removing Trendlines (Skill 7.11)
- Forecasting Values on a Trendline (Skill 7.13)
- Changing Trendline Options (Skill 7.12)
This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.
NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.
- Add Sparklines to the data and apply a Quick Style.
- Change the Sparklines to lines with markers for all data points and highlight the high point marker in a different color.
- Create a column chart to represent the population data for Houston and then add a second series to represent the overall population of the United States.
- Change the chart type to a combination chart with a secondary axis for the national population data.
- Add a legend below the chart and format it by applying a style.
- Change the fill color of a data point to make it stand out.
- Save this chart as a new chart template.
- Add a callout to the chart, apply a style to it, and add text.
- Create a new chart from the template you saved.
- Change the outline color of a data series.
- Create a clustered column chart for population growth by region. Move the chart to its own chart sheet named Regional Trends.
- Edit and format the chart title.
- Add trendlines to the chart to forecast exponential growth for the next 40 years.
Order an Essay Now & Get These Features For Free: