Creating Charts

Charts graphically represent worksheet data, which can make the data easier to understand. You can create charts on the same sheet as your data or on a separate sheet. To create a chart, follow the directions below.
  1. Open the spreadsheet that contains the data you wish to chart.
  2. Select the data that you want to chart.
  3. Click on the Chart Wizard icon in the Standard toolbar.
  4. The Chart Wizard - Step 1 of 4 - Chart Type dialog will appear.

  5. Select your desired chart type in the Chart Type section and choose the desired sub-type in the Chart Sub-Type section. (Note that you can click on the Press and Hold to View Sample button lower right-hand corner of the Chart Wizard dialog to view your chart selection before applying it.)
  6. Click on the Next button.
  7. The Chart Wizard - Step 2 of 4 - Chart Source Data dialog will appear.

  8. Make sure that the correct data cells are listed in the Data Range field.
  9. Click on the Next button.
  10. The Chart Wizard - Step 3 of 4 -Chart Options dialog will appear.

  11. If desired, you may add a chart title in the Chart Title field, an X-axis value in the Category X Axis field, and a Y-axis value in the Value Y Axis field.
  12. Proceed through the other tabs to change various display components of the chart.
  13. Click on the Next button.
  14. The Chart Wizard - Step 4 of 4 - Chart Location dialog will appear.

  15. Determine whether you want the chart as an object embedded in your current worksheet or if you want your chart on a new page within your workbook.
  16. Click on the Finish button.
  17. Your chart will appear in your workbook!
  18. Drag your chart to the desired location if you have embedded the chart in your current worksheet. You can also resize your chart.
Note: Never include totals in the selected chart data, as the charts calculate the totals themselves.

Click HERE to return to the Table of Contents.