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