Not plotting data points in a line chart

[Guest]

I am tracking the weekly data for four series in a line chart. At the end of
the month I do an average column for each series. At the beginning of each
month I start a new chart with each days result for the new month. What I'd
like to do is show the previous months averages (for each series) column in
the data table but not have it plot on the line chart. Anybody have any ideas?

Thanks for your help and advice in advance.

 

[Andy Pope]

Hi,

If you want the series figures in the data table but not the chart then you
just need to format the series to have no border or marker.

The charts data table is very limited in it's formatting capabilities. For
more info see here.
http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

Cheers
Andy