Microsoft Office Tutorials and References
In Depth Information
Alternatives to Pivot Charts
This dataset links back to the data items in your pivot table, so when your pivot table changes, your
dataset changes. Follow these steps to create a standalone chart that is connected to your pivot table:
1. Click in a cell next to your pivot table (see Figure 15-22) and reference the first data item you
want plotted on your chart.
Figure 15-22: Start your linked dataset by referencing the first data item you need to capture.
2. Copy the formula you just entered and paste it down and across to create your complete
At this point, you have a dataset that looks similar to the one in Figure 15-23.
Figure 15-23: Copy the formula and paste it down and across to create your complete dataset.
3. After your linked dataset is complete, use it to create a standard chart.
In this example, you create an XY scatter chart with this data, which you can’t do with a pivot
Figure 15-24 demonstrates how this solution offers the best of both worlds:
➤ You kept the ability to filter out a particular business segment using the Page field.
➤ You have all the formatting freedom of a standard chart without any of the issues related to
using a pivot chart.