Thread: Varying data on X axis

Hi all,

I have a graph that includes a lot of data, it looks messy hard to see individual points. I would like to be able to vary the amount of data points shown at anyone time on the x axis.

I have had a look at adding a scrollbar, but I can only get that to increase the number of points shown. I want to be able to set a limit to the number of points shown at any one time. So if I have 1000 data points I want to able to view points 1 - 100, then 2 - 101, 3 - 102 up to 901 - 1000.

Hope I have explained myself properly, I appreciate any help I can get.

check out pivot tables and or autofilter. By playing with the data
structure, you cna do what you want with either of these.

"coa01gsb" wrote:

>
> Hi all,
>
> I have a graph that includes a lot of data, it looks messy hard to see
> individual points. I would like to be able to vary the amount of data
> points shown at anyone time on the x axis.
>
> I have had a look at adding a scrollbar, but I can only get that to
> increase the number of points shown. I want to be able to set a limit
> to the number of points shown at any one time. So if I have 1000 data
> points I want to able to view points 1 - 100, then 2 - 101, 3 - 102 up
> to 901 - 1000.
>
> Hope I have explained myself properly, I appreciate any help I can get.
>
>
> --
> coa01gsb
> ------------------------------------------------------------------------
> coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
> View this thread: http://www.excelforum.com/showthread...hreadid=508874
>
>

If you are now changing the number of points with your scrollbar, the
defined name you are using has this kind of Refers To formula:

=OFFSET(A1,0,0,linked cell,1)

You want to change it to something like this:

=OFFSET(A1,linked cell,0,100,1)

where "linked cell" refers to the cell containing the value indicated by the
scroll bar.

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


"coa01gsb" <coa01gsb.22t08z_1139222701.6679@excelforum-nospam.com> wrote in
message news:coa01gsb.22t08z_1139222701.6679@excelforum-nospam.com...
>
> Hi all,
>
> I have a graph that includes a lot of data, it looks messy hard to see
> individual points. I would like to be able to vary the amount of data
> points shown at anyone time on the x axis.
>
> I have had a look at adding a scrollbar, but I can only get that to
> increase the number of points shown. I want to be able to set a limit
> to the number of points shown at any one time. So if I have 1000 data
> points I want to able to view points 1 - 100, then 2 - 101, 3 - 102 up
> to 901 - 1000.
>
> Hope I have explained myself properly, I appreciate any help I can get.
>
>
> --
> coa01gsb