Here's a worksheet that shows how many cases of Northwind Traders Tea were sold by each of three salespeople in each of three months. You need a chart that shows how each salesperson compares against the others, month by month for the first quarter of the year.
Select the data that you want to chart, including the column titles (January, February, March) and the row labels (the salesperson names).
Then click the Insert
tab, and in the Charts
group, click the Column
button. You could select another chart type, but column charts are commonly used to compare items and will get your point across.
After you click Column
, you'll see a number of column chart types to choose from. Click Clustered Column
, the first column chart in the 2-D Column
list. A ScreenTip displays the chart type name when you rest the pointer over any chart type. The ScreenTip also provides a description of the chart type and gives you information about when to use each one.
That's it, you've created a chart in about 10 seconds.
Tip If you want to change the chart type after you create your chart, click inside the chart. On the Design tab under Chart Tools, in the Type group, click Change Chart Type, and select another chart type.