Editing Charts - Exercise

Contact Us or call 1-877-932-8228
Editing Charts - Exercise

Editing Charts

Duration: 15 to 25 minutes.

In this exercise, you will edit the charts you inserted in the last exercise.

  1. Open Editing Charts.xlsx from your Excel2013.2/Exercises folder.
  2. On Sheet1, change the layout and style of the chart so that it looks like the image below. Each section of the pie should pastel (or if you are using Excel 2007/2010, it should be a different shade of maroon):
  3. On Sheet2, move the legend, move the title, and add a title to the chart ("Grades by Student") as shown in the image below:
  4. On Sheet3, add styles to the chart such that it has an orange outline, blue fill, and all text is outlined in red:

Solution:

  1. On Sheet1, change the layout and style of the chart:
    1. Select the chart by clicking on it.
    2. On the CHART TOOLS DESIGN tab, in the Chart Layouts group, click Quick Layout and select Layout 1 (in Excel 2007/2010, just select Layout 1):
    3. On the CHART TOOLS DESIGN tab, in the Styles group, click Style 4:
  2. On Sheet2, move the legend and the title and change the title of the chart:
    1. Select the chart by clicking on it.
    2. On the CHART TOOLS DESIGN tab (Chart Tools Layout tab in Excel 2007/2010), in the Chart Layouts group (Labels group in Excel 2007/2010), click Add Chart Element and select Legend and select Right (Data Labels command in Excel 2007/2010 and select Show Legend at Right)
    3. On the CHART TOOLS DESIGN tab (Chart Tools Layout tab in Excel 2007/2010), in the Chart Layouts group (Labels group in Excel 2007/2010), click Add Chart Element and select Chart Title and then select Centered Overlay (in Excel 2007/2010, select Chart Title and select Centered Overlay Title):
    4. Click in the Chart Title box, select the text, and type "Grades by Student".
  3. On Sheet3, add styles to the chart so that it looks like the image shown:
    1. Select the chart by clicking on it.
    2. On the CHART TOOLS FORMAT tab, in the Shape Styles group, click the orange Colored Outline (you may have to click the More button to see the orange outline):
    3. On the CHART TOOLS FORMAT tab, in the Shape Styles group, click Shape Fill and then select a color:
    4. On the CHART TOOLS FORMAT tab, in the WordArt Styles group, click Text Outline and then select Red:
Next