Inserting Charts - Exercise

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

Inserting Charts

Duration: 15 to 25 minutes.

In this exercise, you will practice inserting charts in Microsoft Excel.

  1. Open Charts.xlsx from your Excel2013.2/Exercises folder.
  2. In Sheet1, insert a pie chart that looks like the one below:
  3. In Sheet2, insert a line chart that looks like the one below:
  4. In Sheet3, insert a column chart that looks like the one below:

Solution:

  1. To insert a pie chart in Sheet1:
    1. Select cells A1:B35 (do not remove subtotals or display all the data) or select any cell in the range.
    2. On the INSERT tab, in the Charts group, click the Pie chart command:
    3. Select the -D Pie (Pie in 3-D in Excel 2007/2010) chart by clicking on it:
  2. To insert a line chart in Sheet2:
    1. Select cells A1:H8 or select any cell in the range.
    2. On the INSERT tab, in the Charts group, click the Line chart command:
    3. Select the Line chart by clicking on it:
  3. To insert a column chart in Sheet3:
    1. Select cells A1:E8 or select any cell in the range.
    2. On the INSERT tab, in the Charts group, click the Column chart command:
    3. Select the Clustered Column chart by clicking on it:
Next