Overview

Basics

Navigating in Excel

Data Types

Sorting Data

Alignment & Formatting

Importing & Printing

Functions

Charts & Graphs

Evaluate this tutorial

Charts & Graphs

Charts & Graphs

Creating a Pie Chart

1. Select Insert from the menu



2. Select the Pie chart type and choose your Chart sub-type and click next.



3. Click on the Series tab to begin selecting cells in order to populate the chart.



4. 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.



5. When you are done selecting values, click Next



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



7. 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.



8. The finished object will look like this.

Creating a Bar Chart with Two Series

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



2. 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.



3. Select the Name, Values and Category Labels for the first series.



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



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



6. The finished two series bar chart will look like this.

Watch the video

choose format/speed
dial-up | broadband

html transcript