If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to handle lots of data
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 |
#2
|
|||
|
|||
How to handle lots of data
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting a new line when external data changes | Rental Man | General Discussion | 0 | January 11th, 2006 07:05 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |