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!