how do I show filter information on a pivot chart in excel2007?

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

In the previous version of Excel that I used you had the option to show Pivot
Chart buttons which detailled how the chart had been filter. I can't find a
replacement for this in 2007 so if someone prints the chart it isn't
comprehensive in that you can't tell how it's been filtered. I create a lot
of these for less experienced users and this info can be critical since
descisions are made based on these charts. Can anyone help please?
 
Hi,
See the reply to my question about the same issue (added 16/9).
That works. You just need to modify the macro for every spreadsheet.

I'll have a go at modyfying it so that it is it works for any pivotchart.

Niklas

"Russ" skrev:
 
Hi,
Thanks, but... I searched for your post but couldn't find it, was it
16/9/2009? can you give me anymore detail please?
 

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

Similar Threads

Excel 2007 Pivot charts, any way to display filters on the chart? 1
Pivot table chart problem, How to show different subtotal levels 2
How do I make a custom chart layout in Excel2007 1
Pivot charts filter field in 2007 3
Remove series from Pivot Chart 2
How do i export a pivot chart as a static chart object? 2
How do I update charts in excel 2007 2
How do I show the Grand Total on a Pivot Chart? 1

Back
Top