eg, i have a series of data
X(date) Y
1/1 100
1/2 180
1/3 305
1/4 420
1/5 500
......
8/29 350 (y min=100. max=500)
I would have a chart with x axis (time frame), and y axis (0 to 500).
is it possible to draw only the recent 500 days data each time if i were to continue adding more data. and how to set the Y axis range so that the 500 days data min and max range is drawn. (eg, if the recent 500 days data is from 300 to 500, would show only Y axis 300 to 500)