Home |
Search |
Today's Posts |
#1
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
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart/Graph to show 3 pieces of information | Charts and Charting in Excel | |||
Show the item selected from Report Filter in a Pivot Chart | Excel Discussion (Misc queries) | |||
Show selected filter in a pivot chart (2007 version) | Excel Discussion (Misc queries) | |||
excel2007 pivot table chart x-axis | Charts and Charting in Excel | |||
pivot tables using same heading to show multiple data information | Charts and Charting in Excel |