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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.