A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Varying data on X axis



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2006, 11:44 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 6th, 2006, 02:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 6th, 2006, 03:48 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01:01 PM
Excel Macro to Copy & Paste [email protected] Worksheet Functions 0 December 1st, 2005 02:56 PM
Pulling data from 1 sheet to another Dave1155 Worksheet Functions 1 January 12th, 2005 06:55 PM
Format on data to import to Access tables? (I need your advice) Niklas Östergren General Discussion 5 December 13th, 2004 03:54 PM
data to chart on primary axis jw Charts and Charting 6 September 24th, 2003 12:46 AM


All times are GMT +1. The time now is 05:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.