Page 9 of 14PREVNEXT

Charts I: How to create a chart

Selecting either Rows or Columns at the Series in option changes what the chart says

The way you choose is to select either Rows or Columns at the Series in option.

Suppose you wanted to compare salespeople, not to each other, but to themselves, so you can see their performance over time. Once again you would select the Sir Rodney's Marmalade data and open the Chart Wizard by clicking the Chart Wizard Button image button.

But this time you'd click the Next button instead of clicking Finish. That click will display the Data Range tab as Step 2 of the Chart Wizard.

Data Range tab

On this tab you could change your chart structure.

The chart from the first lesson (on the left in this picture) compares the salespeople to each other, month after month. To make this comparison, Excel grouped by worksheet columns and compared worksheet rows. If Excel grouped by rows and compared by columns, the chart would say something completely different. It would show how each salesperson did, better or worse, month by month, as shown on the right of the picture.

You could choose which comparison to make by selecting either Rows or Columns in the Series in option. The option has that name because the worksheet values used in the chart are called data series. You choose whether to compare and group the series in rows or columns.

You can see the result of your choice in the preview on the tab.

In the practice session you'll try out this choice for yourself.

Series tab

On this tab you can delete or add a data series for the chart. For example, you might decide to chart only two of the salespeople instead of all three that you selected on the worksheet. The tab lets you change without going back to the worksheet, and it previews your changes.

Note     Deleting or adding a data series on this tab does not alter the data on the worksheet.

Page 9 of 14PREVNEXT