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

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

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" wrote:

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

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"OkieViking" wrote in message
...
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" wrote:

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

Never mind.

I found the answer. it is really simple.

Thanks Andy

"OkieViking" wrote:

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" wrote:

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