Excel 2010: How to display PivotChart Report Filter Lables on the graph

  • Thread starter Thread starter Zack F
  • Start date Start date
Z

Zack F

In Excel 2003, when a PivotChart is created and 'page filters' were
used, the name of the field/column would be displayed and next to that
field/column would be the name of the attribute/variable being used to
filter the dataset.

For example, if I had a dataset which contained 'Country' as a field/
column, and I only wanted to analyze or view one country at a time, I
may drag the 'Country' field to the page filter. Then, if I want to
only look at information from Germany, I would select 'Germany' in the
'Country' drop down within the page fiter. If I were to do that, on
the PivotChart, I would see: "Country Germany". This is nice because
if you copy this chart into a presentation, you'll know, without
having to rely on updating the chart title, for which 'Country' the
chart applies.

In Excel 2010, the 'page filter' has turned into a 'report filter',
but the concept is the same. What I can not figure out however is how
to display the field/column name ("Country") _and_ the attribute/
variable ("Germnay") that I'm using to filter the data.

Anyone have a suggestion???
 
In Excel 2003, when a PivotChart is created and 'page filters' were
used, the name of the field/column would be displayed and next to that
field/column would be the name of the attribute/variable being used to
filter the dataset.

For example, if I had a dataset which contained 'Country' as a field/
column, and I only wanted to analyze or view one country at a time, I
may drag the 'Country' field to the page filter.  Then, if I want to
only look at information from Germany, I would select 'Germany' in the
'Country' drop down within the page fiter.  If I were to do that, on
the PivotChart, I would see: "Country Germany".  This is nice because
if you copy this chart into a presentation, you'll know, without
having to rely on updating the chart title, for which 'Country' the
chart applies.

In Excel 2010, the 'page filter' has turned into a 'report filter',
but the concept is the same.  What I can not figure out however is how
to display the field/column name ("Country") _and_ the attribute/
variable ("Germnay") that I'm using to filter the data.

Anyone have a suggestion???
Click to expand...

My solution to all problems like this is to use the old pivot table
layout.

right click in the table - Pivot Table Options - Display - Classic
Pivot Table Layout - OK
 
My solution to all problems like this is to use the old pivot table
layout.

right click in the table - Pivot Table Options - Display - Classic
Pivot Table Layout -  OK- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks for the reply, but my Pivot Table is already in 'classic'
mode. My issue is with the Pivot Chart.
 
Back
Top