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/p...cle.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

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/
_______

Mian Mazher wrote:

> 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/p...cle.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