Chart with filterable legend

S

stuartmarsh

I have a chart that has a few items in the legend.
Is it possible to have the pull down legend like a PivotChart has?
I cannot use an actual PivotChart for this report because of the way
the data is calculated.
Is it possible to enable an option in VBA?

Any help would be great.

Thanks.
 

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

Similar Threads

Excel 2007. Is it possible to format Legend Key? 3
Bubble Chart Legend 10
legend keeps changing 1
edit chart legend spacing 11
How do I find the series associated with a given legend entry. 4
chart legend changing when I use Select data 1
Pivot Table Chart Legend 2
Legend and text entry 1

Top