Chart Problem ( X-Axis Shrinks as new data added)

[Mian Mazher]

Dear Forum Members,
This is my first post in this forum.

I have made a chart using the following Informative link by Jon
Peltier
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=246

The chart have a large range comprising of abt 1500 rows.


I am using the simple Line Chart.

I want to see the chart of data covering 200 rows at a time .

but when I add data abt 17 rows it shrinks and doesnt show me the
chart of all the data




I have added the slidders to control the Sart and the end dates.

I have start Date in cell G1=02-01-1998
I have End Date in cell G2=27-01-1998

I have add the sliders and linked to cells H1 and H2 .

I have used the following formula sin cell H1 and H2
H1==INDEX(AllDates,MIN(H1:H2))
H2==INDEX(AllDates,MAX(H1:H2))

The values in Hi and H2 are 1 and 17 Respectively.

My problem is that the moment I increment the slider and the value in
cell H2 changes to 18 the chart shrinks .

Whether X axis cannot display more than 18 values. If yes how can I
make my chart dat avisible and fit to the chart screen .


Hope that My Problem will be solved.


Regards

 

[Jon Peltier]

You have formulas in the same cells that your sliders are linked to. As
soon as you move a slider, the formula will be obliterated by the new
value of the slider.

I don't know what you mean when you say the chart "shrinks". Reminds me
of an old Seinfeld episode, which certainly doesn't help here.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______