Chart with filterable legend

[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.

 

[Andy Pope]

Hi,

Have a look at this.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

 

[stuartmarsh]

Thanks this looks promising