Page 4 of 14PREVNEXT

Charts I: How to create a chart

Worksheet row data is transformed into chart columns

Worksheet rows become chart columns. Row titles become the chart legend text, and column titles become the category names at the bottom of the chart.

Each row of salesperson data has been given a color in this chart. The chart legend, which was created from the row titles in the worksheet, tells which color represents the data for each salesperson. Peacock data, for example, is lavender. Data for each salesperson appears in three separate chart columns, one for each month.

Cell B2 from the worksheet becomes the January chart column for Peacock, cell C2 becomes the February column for Peacock, and cell D2 becomes the March column for Peacock. Each chart column reaches a height proportional to the value in the cell that it represents. You can see at once how the salespeople stack up against each other, and month by month.

On the left side of the chart, Excel has created a scale of numbers by which you can interpret the column heights.

The column titles from the worksheet are now at the bottom of the chart. The titles become the categories in which the values from the worksheet rows are arranged.

As you can see at once, the chart shows that Suyama sold the most marmalade in January and February, but she had a slump in March, when Peacock did best.

Page 4 of 14PREVNEXT