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

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

Russ

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

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:

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

Russ

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

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

Russ


"dNd BdN" wrote:

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:

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

Russ

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

Don't worry, found it now. Refreshed the page after replying to you
an...da,daaaa! :-)
--
ATB

Russ


"dNd BdN" wrote:

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:

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

Russ