Dear All,
I want to know whether there is such function in Ms Excel?..
For example, I have some data series consisting 100 data..and every month I
will add 1 data into the series..
And I want to create a chart showing the 10 latest data... in this regard,
every time I add a data, automatically (or by clicking some button)...the
chart will updating the data by add the new one and remove the oldest one,...
so the chart still consist the 10 latest data...
what i've been doing right now is only by dragging the data source area....
and since i will deal with more than 20 charts, this action quite time
consuming (since I put all charts in 1 sheet and the other sheets consist
of data for each charts)..

I am sorry that my english is not good.. but I hope all of you can
understand what I mean.. and help me with this issue..

thanks a lot..