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