software

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: www.excelforum.com/member.php...oamp;userid=31214
View this thread: www.excelforum.com/showthread...hreadid=508874check out pivot tables and or autofilter. By playing with the data
structure, you cna do what you want with either of these.

quot;coa01gsbquot; wrote:

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

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 quot;linked cellquot; 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
PeltierTech.com/
_______quot;coa01gsbquot; gt; wrote in
message ...
gt;
gt; Hi all,
gt;
gt; I have a graph that includes a lot of data, it looks messy hard to see
gt; individual points. I would like to be able to vary the amount of data
gt; points shown at anyone time on the x axis.
gt;
gt; I have had a look at adding a scrollbar, but I can only get that to
gt; increase the number of points shown. I want to be able to set a limit
gt; to the number of points shown at any one time. So if I have 1000 data
gt; points I want to able to view points 1 - 100, then 2 - 101, 3 - 102 up
gt; to 901 - 1000.
gt;
gt; Hope I have explained myself properly, I appreciate any help I can get.
gt;
gt;
gt; --
gt; coa01gsb