March 2007
Intermediate to advanced
704 pages
21h 31m
English
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 ...
Read now
Unlock full access