Excel Basics
Computing Resources >> Tutorials >> Office Suite >> Excel Basics  

Overview

Basics

Navigating in Excel

Data Types

Sorting Data

Alignment & Formatting

Importing & Printing

Functions

Charts & Graphs

Evaluate this tutorial

 

Charts & Graphs

Charts & Graphs

screen shot

Creating a Pie Chart

  1. Select Insert from the menu
  2. screen shot

  3. Select the Pie chart type and choose your Chart sub-type and click next.
  4. screen shot

  5. Click on the Series tab to begin selecting cells in order to populate the chart.
  6. screen shot

  7. To select a range of cells to populate your chart Name, Values, and Category Labels, click the button to the right of each blank. A smaller Chart Source Data window will appear (as seen below) and you can select a range of cells to populate it. Once you have selected the cells, click the button again to return to the main Chart Source Data screen.
  8. screen shot

  9. When you are done selecting values, click Next
  10. screen shot

  11. The next screen enables you to adjust various chart options, including how the labels will appear on your chart.
  12. screen shot

  13. The final step is to specify where you would like your chart to appear. You can have it appear as a new worksheet or as an object in your current worksheet or others.
  14. screen shot

  15. The finished object will look like this.
  16. screen shot

Creating a Bar Chart with Two Series

  1. Select the Bar chart type and choose your Chart sub-type and click next.
  2. screen shot

  3. Click on the Series tab to begin selecting cells in order to populate the chart. Next click the add button to begin adding your first series.
  4. screen shot

  5. Select the Name, Values and Category Labels for the first series.
  6. screen shot

  7. Click the Add button again to create your next series. Once again, select the Name, Values and Category Labels for the second series.
  8. screen shot

  9. Make adjustments to the layout and design of your chart. In this example we have added Values to the bar graph.
  10. screen shot

  11. The finished two series bar chart will look like this.
  12. screen shot

Evaluate this tutorial

 

Watch the video
screenshot
choose format/speed
real media dial-up | broadband

html transcript

© 2004 Sam Burns | iSchool | UT Austin | webmaster