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
|
|||
|
|||
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. -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=508874 |
#2
|
|||
|
|||
Varying data on X axis
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 |
#3
|
|||
|
|||
Varying data on X axis
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query does not order the same data in the same way | Milković Aleksandar | Running & Setting Up Queries | 10 | December 15th, 2005 12:01 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |