Spreadsheets

Unit 2: Creating More Effective Spreadsheets

Lesson 7: Creating and Modifying Charts

Example: Creating a bar chart.

The following animation demonstrates how to create a simple bar chart.

Some notes on the above animation:

1. A pie bar chart can be used to graph multi series data. In other words, the data for a bar chart may come from a two-dimensional table in your spreadsheet.

2. When graphing a two-dimensional table, you select one dimension (rows or columns) to be the series data. Each series is assigned a different color.