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:Pie Chart
  3. In Sheet2, insert a line chart that looks like the one below:Line Chart
  4. In Sheet3, insert a column chart that looks like the one below:Column Chart

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:Pie chart Command
    3. Select the -D Pie (Pie in 3-D in Excel 2007/2010) chart by clicking on it:D Pie Option
  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:Line chart Command
    3. Select the Line chart by clicking on it:Line Chart
  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:Column chart Command
    3. Select the Clustered Column chart by clicking on it:Clustered Column Chart
Next