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
|