How to handle lots of data

  • Thread starter Thread starter coa01gsb
  • Start date Start date
C

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
 
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/ExcelTips/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.
 
Back
Top