How to show recent data range on charts......?


Posted by ---------------------------------------------------------Ian on October 03, 2001 3:59 AM

I have the following data :

..A ...B ..C ..D ..E .F
9/20 500 10 10 10 10
9/21 700 15 15 15 15
9/22 400 20 20 20 20
9/23 900 25 25 25 25
.
.

If I want the recent 500 days Date range data to show on chart, and the Y-axis should has the min and max set to the recent 100 days range, How to make the VB for this?

Thanks,

Ian



Posted by Eric on October 03, 2001 8:48 AM

I'm not sure I'm getting what you're asking

If you added a column and put in the formula
=round(now()-a2,0)
and copied down, it would give you the number of days between the present date and the date in col A.

Then if you plotted your data as an X-Y graph with the new "day difference" column data as the X axis, and set the X axis range on the chart to min 0 max 100 it would only plot the data of the last 100 days.

Sorry if that's too off target.