show pivot filter on chart excel 2007

[ghynes]

anyone know of a way to show a certain pivot filter on chart excel 2007 (so it can be used as a title on the chart)?


thanks.

 

[Trevor G]

When creating your Pivot Table you get the option to use Pivot Chart which will allow you to filter in the Chart, is this what you mean?

 

[ghynes]

i have the charts already created. but i want to show a certain filter on the chart title(or at the top left hand corner) or else show the filter on the chart (just like 2003)

 

[GlennUK]

Select the chart title, and then in the formula bar type a reference to the cell where the pivot filter exists, like:
=SheetName!$B$3

( not tested on PivotChart )

 

[ghynes]

that works!. but is there anyway i can reference the pivot data instead of a cell data? cos if i change the report filter, the name will stay the same

 

[ghynes]

oooooh. i just changed the reference to the actual sheet where the pivot data is and it worked! thanks a million.

 

[GlennUK]

That's great!

 

[james_lankford]

ok, been trying to figure this out for about 15 minutes, looked all over the various ribbons, couldn't find the option, came here, found this solution pretty quick

thank you

I wonder if the people who made excel 2007 ever used it before deciding on all these changes from 2003