Hi,

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

Cheers
Andy

stuartmarsh wrote:
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, Microsoft MVP - Excel
http://www.andypope.info