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