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

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???
 
X

Xt

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???

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
 
F

FALLOWFZ

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 -

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top