How to handle lots of data

[coa01gsb]

Hi people,

My problem is I have a graph with lots of data on it, so much that it is hard to spot useful inofrmation in it. Short of simply expanding the graph width, or making multiple graphs of different sections of data, how else can I sort this out?

I have found a scroll bar object that one can add to charts that looks promising but can only get it to add more data to the graph, so the graph displays point1, if you move the scroll bar one unit the graph displays point 1 and point 2, then point 1,2,3 and so on. how can you st it up to show a max of say 10 points, such that when you move the bar it changes the visible data from points 1 - 10 to points 2 - 11, then 3 - 12, and so on?

All help much appreicated, apologise for slack explaination

[Bernard Liengme]

I will assume your data is arranged:
A1 and B1 are labels
A2:Abigbumber is the x-values
B2:Bbignumber is the y-values
That the slider is connect to cell C1
Use Insert|Name and define two names
xRANGE =OFFSET(Sheet1!$A$1,Sheet1!$C$1,0,10)
yRANGE =OFFSET(Sheet1!$B$2,Sheet1!$C$1,0,10)

Make a chart of the first 10 items;
Right click chart, open Source Data dialog
In the Values box enter: Sheet1!yrange
In the Category box enter Sheet1!xrange
The method we are using is similar to making a dynamic chart except that we
are specifying a start cell and a height; see
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Move the slider and the chart displays 10 new data items.
Send me private mail and I'll return a simple file.
best wishes.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"coa01gsb" <[email protected]> wrote in
message news:[email protected]...
>
> Hi people,
>
> My problem is I have a graph with lots of data on it, so much that it
> is hard to spot useful inofrmation in it. Short of simply expanding the
> graph width, or making multiple graphs of different sections of data,
> how else can I sort this out?
>
> I have found a scroll bar object that one can add to charts that looks
> promising but can only get it to add more data to the graph, so the
> graph displays point1, if you move the scroll bar one unit the graph
> displays point 1 and point 2, then point 1,2,3 and so on. how can you
> st it up to show a max of say 10 points, such that when you move the
> bar it changes the visible data from points 1 - 10 to points 2 - 11,
> then 3 - 12, and so on?
>
> All help much appreicated, apologise for slack explaination
>
>
> --
> coa01gsb
> ------------------------------------------------------------------------
> coa01gsb's Profile:
> http://www.excelforum.com/member.php...o&userid=31214
> View this thread: http://www.excelforum.com/showthread...hreadid=514370
>