Have chart w/ data table - how can i control which series plot
 

I have a chart that has a data table attached. I need several pieces of data
in the table but i only want to chart one of them. Is there a way to assign
this?

The only way I can think of doing it is to go in and format the series with
no fill/color and no line. But if I do this the scale of the chart could
still be controled by one of the larger series that doesn't get plotted.

I know it can be done because I have one that someone did, but I just can't
figure it out. Any ideas?

Thanks!

Have chart w/ data table - how can i control which series plot
 

All data in the data table gets plotted, but you could format a series to
hide it (no border, no line, no fill).

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


"ShannaD" wrote in message
...
I have a chart that has a data table attached. I need several pieces of
data
in the table but i only want to chart one of them. Is there a way to
assign
this?

The only way I can think of doing it is to go in and format the series
with
no fill/color and no line. But if I do this the scale of the chart could
still be controled by one of the larger series that doesn't get plotted.

I know it can be done because I have one that someone did, but I just
can't
figure it out. Any ideas?

Thanks!