Using PivotCharts
A PivotChart is just a PivotTable in another form—it’s also an Excel chart just like any Excel chart, but with additional functionality.
In fact, the column chart that follows, also shown earlier in this chapter as a comparison to a basic PivotTable, is actually a PivotChart. It’s available for your perusal in the sample file(Pivot Tables.xlsx) referenced earlier.
Yes, it looks exactly like a regular column chart, and you can use it as a regular column chart if you choose. The only difference, as shown in the image that follows, is that you get added functionality when you select this chart. Notice the contextual PivotChart Tools ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
