Hi,

If you hide the columns the information will not be plotted. Make sure the
setting Plot visible cells only is on. Select chart and use menu Tools
Options Chart Plot visible cells only.

If your data was laid out in rows then you could use Auto filter.

Another approach is,
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"OkieViking" wrote in message
...
I have a large number of parameters I want to plot on the same plot to look
for trends. However, I can't see with so much data on one plot. Is there
a
way to quickly switch what data to display on a plot? i.e. if I have 30
columns of data in a plot, can I easily choose to not display 15 of them
(and
then toggle back to displaying them)?