O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Multilevel Categories

Excel allows you to categorize your categories. This sounds redundant, but a quick example illustrates the technique. Suppose you want to plot the data shown in Figure 26-9 (The resulting chart is shown in Figure 26-10). 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 normal manner. Excel recognizes the second category column and creates the appropriate subcategories.

This worksheet uses multilevel categories; city sales offices are grouped by the states in which the cities are located.

Figure 26-9. This worksheet uses ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required