Microsoft Office Tutorials and References
In Depth Information
Using data from multiple sheets
Figure 9-24: Here are the pivot table and pivot chart after changing the Page field
to a Row field, changing the item names, and removing the grand totals.
In this particular case, there is a partial solution: use the “Line - Column on 2
Axes” custom chart type. As luck would have it, this custom chart type
displays the Ratio series as a line that uses the secondary axis. But you’ll notice
that a custom chart type is not maintained when the pivot table’s layout is
changed or when it’s refreshed. However, re-specifying the chart type is much
easier than performing the individual customizations described previously.
Figure 9-25: The pivot chart, after making some modifications