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

[ShannaD]

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!

 

[Jon Peltier]

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

- Jon