Updating charts - monthly

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi All,

I have a spready with 8 charts that mostly consider rolling average data.

Whilst I have the data table set up to go out to the end of the year, when I
chart the data, I only want to see up to the end of the previous month.

I have been going into my charts on a monthly basis and extending each of
the series to add the new months data into the chart.

This is somewhat tedious and I know there is bound to be a better way.

I'd appreciate the groups thoughts on possible methods....

Thanks,

Neil
 
Thanks Frank,

Wasn't sure how to implement named ranges effectively, the referenced web
pages below cover it very well.

Regards,

Neil
 
Back
Top