1.

Non-graded - Getting Started with Excel Charts

2.

Creating a Pie Chart

To move and resize the pie chart

3.

Working with Chart Elements

To format a data label

To move and format the pie chart legend

4.

Performing What-If Analyses with Charts

To modify the pie chart's data

5.

Creating a Column Chart

To create a clustered column chart

To change the title of the column chart

To add vertical gridlines to the chart

6.

Creating a Line Chart

To create the growth history line chart

To format the horizontal axis

To display and format the line chart data markers

7.

Creating a Combination Chart

To create the combination chart

To move and format the combination chart

To add axis titles to the chart

8.

Creating a Scatter Chart

To create a scatter chart

9.

Non-graded - Editing the Chart Data Source

10.

Adding Graphic Objects to a Workbook

To insert the star icons from the icon gallery

11.

Non-graded - Exploring Other Chart Types

12.

Creating Data Bars

To add data bars to the portfolio percentages in the worksheet

To modify the data bar conditional formatting rule

13.

Creating Sparklines

To create the line sparklines showing the sector history growthtrends

To format the sparklines