"Del Cotter" wrote in message
...
On Tue, 23 May 2006, in microsoft.public.excel.charting,
BenWeber said:

Are there any vba functions to change the data displayed in the data area
of
the chart and/or legend text through VBA (ie not using the wizard, instead
need to do this in code)?

Specifically, I would like to put checkboxes on a worksheet to enable the
user to turn on-and-off data that's displayed in a chart (there's about 10
stats they could choose from, and it gets busy if all are shown).

Pivot tables let you check and uncheck ranges. You may also be able to use
the controls available in the Form Design toolbar, if you don't want to
use a Pivot chart.

For example:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______