Show current Report Filtered in Pivot Chart


J

JMay

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
 
Ad

Advertisements

S

Suleman Peerzade

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
 
J

JMay

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
 
S

Suleman Peerzade

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
 
J

JMay

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

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top