Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current Report Filtered in Pivot Chart
I use Excel 2007. I have a pivot table set up with a Report Filter showing
all the months of the year. Is it possible if I select the items from the Report Filter, for example "Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot Chart |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current Report Filtered in Pivot Chart
Hi,
Yes it is possible, right click on the chart go to, chart options|Data labels|Click the check box catagory name|Ok. This will make the names Jan, Feb appear on the chart -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "JMay" wrote: I use Excel 2007. I have a pivot table set up with a Report Filter showing all the months of the year. Is it possible if I select the items from the Report Filter, for example "Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot Chart |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current Report Filtered in Pivot Chart
Sorry, but not clear on yur instructions.. I selected pivot-chart, From
Layout Group I see the data labels (as you suggest), clicked drop-down - Checked Category OK but didn't get the results I was looking for. This should be Dynamic. Any other thoughts? Tks, Jim "Suleman Peerzade" wrote: Hi, Yes it is possible, right click on the chart go to, chart options|Data labels|Click the check box catagory name|Ok. This will make the names Jan, Feb appear on the chart -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "JMay" wrote: I use Excel 2007. I have a pivot table set up with a Report Filter showing all the months of the year. Is it possible if I select the items from the Report Filter, for example "Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot Chart |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current Report Filtered in Pivot Chart
If the word "Jan", "Feb", and "March are the names of the catagory then it
should appear. Please correct me if have not understood you -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "JMay" wrote: Sorry, but not clear on yur instructions.. I selected pivot-chart, From Layout Group I see the data labels (as you suggest), clicked drop-down - Checked Category OK but didn't get the results I was looking for. This should be Dynamic. Any other thoughts? Tks, Jim "Suleman Peerzade" wrote: Hi, Yes it is possible, right click on the chart go to, chart options|Data labels|Click the check box catagory name|Ok. This will make the names Jan, Feb appear on the chart -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "JMay" wrote: I use Excel 2007. I have a pivot table set up with a Report Filter showing all the months of the year. Is it possible if I select the items from the Report Filter, for example "Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot Chart |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current Report Filtered in Pivot Chart
Suleman,
I'm having difficulty (adjust to Ribbon in 2007 at the same time I have my original problem). When I right click on the chart - I don't see the (goto) "Chart options", of which you speak, can you give me step by step on this? "Suleman Peerzade" wrote: Hi, Yes it is possible, right click on the chart go to, chart options|Data labels|Click the check box catagory name|Ok. This will make the names Jan, Feb appear on the chart -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "JMay" wrote: I use Excel 2007. I have a pivot table set up with a Report Filter showing all the months of the year. Is it possible if I select the items from the Report Filter, for example "Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot Chart |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current Report Filtered in Pivot Chart
Excel 2007
This will show the selected items of the Report Filter (Page selection) in the Chart Title header. Some VBA required. http://www.mediafire.com/file/dndt1kqjyl4/01_21_09.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show the item selected from Report Filter in a Pivot Chart | Excel Discussion (Misc queries) | |||
How do I create a chart that will show 4 weeks of current info? | Charts and Charting in Excel | |||
Change a legend in Pivot Chart Report | Excel Discussion (Misc queries) | |||
Pivot Chart Report | Excel Discussion (Misc queries) | |||
Pivot Chart Report - formatting | Charts and Charting in Excel |