quick change of data

[Guest]

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)?

 

[Andy Pope]

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

 

[Guest]

Thanks Andy!

I was just about to respond to my post as I found the peltier site. My
situation has one more level of complexity (at least to me) to it:

The data I am plotting is a series of 'x' data plotted against one 'y' data
column. The data is in columns. I am sure hiding the columns will work fine
(I will try it right now), but I have to admit I like the control box option.
Can I use a control box solution ala Peltier in my situation?

Thanks!

 

[Andy Pope]

Yes it should do. Setting either the x or y value to NA() results in the
point not being plotted.

Cheers
Andy

 

[Guest]

Never mind.

I found the answer. it is really simple.

Thanks Andy