|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 14th, 2009, 10:45 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
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 
|
|
#2
September 18th, 2009, 08:20 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
|
|
#3
September 18th, 2009, 08:35 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
|
|
#4
September 18th, 2009, 08:39 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
