Microsoft® Office Excel® 2007 Inside Out

Using Multilevel Categories

Excel lets you categorize your categories. This sounds redundant, but a quick example illustrates the technique. Suppose you want to plot the data shown in Figure 20-20. (Figure 20-21 shows the resulting chart.) The series are months, and the categories are the sales offices located in different cities. The city sales are further classified by state, however. To create this multilevel chart, you simply select the data, including both columns of category information, and plot in the usual manner. Excel recognizes the second category column and creates the appropriate subcategories.

Figure 20-20. This worksheet uses multilevel ...