Pivoting a PivotChart


show more Pivoting a PivotChart provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Pivoting a PivotChart

The real power of a PivotChart comes to the fore when you rearrange your data dynamically. A task that would take several minutes if done by hand takes just a few seconds when you summarize your data using a PivotChart. So now let's say that you have a PivotChart and you want to pivot it. You can pivot either the PivotChart itself or the PivotTable behind it. So let's start out by pivoting the PivotTable, which is on the left side of the screen. I currently have the data laid out by Year and Month along the rows, which is along the horizontal axis on this line chart, and then Company which provides the FirmA and FirmB lines.

So there are two separate lines. Each one represents a single company. If I were to remove Company from the Column Labels area by dragging it out then Excel creates a chart where it summarizes all of the data instead of separating it out by company. Now let's say that I want to create a separate line for each year. So in other words I want to have January,...

Pivoting a PivotChart
Video duration: 3m 5s 3h 43m Intermediate

Viewers:

Pivoting a PivotChart provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...