Updating charts - monthly

[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

 

[Frank Kabel]

Hi
have a look at the following sites for creating dynamic charts:
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html

 

[Neil]

Thanks Frank,

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

Regards,

Neil