want chart to update automatically every month

[NYBoy]

I would like the chart to update automatically when monthly data i
entered.

Every 1st of the month I update the data to add new month values.

I like the chart to update automatically.
And, I want my chart to show only past 12 month period data. It mean
every month when I add data in the spreadsheet, the chart shoul
automatically drop the the first month values and add last month. S
that, chart would present trend line within past 12 months always.

Presently, I enter the data in the spreadsheet and then go to th
chart, right click and change source data.

It's a line chart.

Any input is appreciated

 

[Earl Kiosterud]

NYBoy,

You need a special kind of "dynamic range." Do Insert - Name - Define.
Give it a name (MyYData), and in "refers to," paste:

=OFFSET(Sheet1!$B$2,COUNTA(Sheet1!$B$2:$B$65536)-12,0,12,1)e

This is for data that starts in B2.
In the data source, use:

=Book1.xls!MyYData

Do the same for the labels (x).