Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Suppose you decide to create a pivot chart from this pivot table. You would instinctively expect to
see fiscal periods across the x-axis and lines of business along the y-axis. However, as you can see in
Figure 15-6, your pivot chart comes out with Region in the x-axis and Sales Period in the y-axis.
Figure 15-6: Creating a pivot chart from your nicely structured pivot table doesn’t yield the results you expected.
So why doesn’t the structure in your pivot table translate to a clean pivot chart? The answer has to do
with the way pivot charts handle the different areas of your pivot table.
In a pivot chart, both the x-axis and the y-axis correspond to a specific area in your pivot table.
➤ The y-axis of your pivot chart corresponds to the column area in your pivot table.
➤ The x-axis of your pivot chart corresponds to the row area in your pivot.
Given this new information, look at the pivot table in Figure 15-5 again. This structure says that the
Sales_Period field will be treated as the y-axis because it is in the column area. Meanwhile, the Region
field will be treated as the x-axis because it is in the row area.
Now suppose you rearrange the pivot table to show fiscal periods in the row area and lines of
business in the column area, as shown in Figure 15-7. This format makes reading more difficult in a pivot
table view, but it gives your pivot chart the effect you want (see Figure 15-8).
Figure 15-7: Moving fiscal periods to the row area allows your pivot chart to accurately plot the data.