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.
--
Misanthrope