Graph with too many points - How to scroll?
 

Hi all,

I have a graph with a lot of points, so I wanted to create some kind of
horizontal scroll bar so I would be able to use a better scale and move
around my time line ? Has anyone of you done something like that ?

thx


--
giselle
------------------------------------------------------------------------
giselle's Profile: http://www.excelforum.com/member.php...o&userid=24222
View this thread: http://www.excelforum.com/showthread...hreadid=378389

Hi,

Jon Peltier has written an article on the subject.
http://pubs.logicalexpressions.com/P...cle.asp?ID=246

Cheers
Andy

giselle wrote:
Hi all,

I have a graph with a lot of points, so I wanted to create some kind of
horizontal scroll bar so I would be able to use a better scale and move
around my time line ? Has anyone of you done something like that ?

thx



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi all,
Advanced a little after reading link provided and some others I've
found.
Im stuck now having problems with the offset function. when I choose
the parameter height = 1 everything works fine, but when I try to bring
more than 1 record, I get the #value error. ( No, it's not falling out
of the range of values I have).
I've tried everything. Im attaching my graph in case somebody can take
a look at it. Thx !

oops, just realized I can not add attachments, here's the code:

=OFFSET(A2;$I$25;0;$I$26;1)

When I26 is 1, no problems, when is not ...... :confused:


--
giselle
------------------------------------------------------------------------
giselle's Profile: http://www.excelforum.com/member.php...o&userid=24222
View this thread: http://www.excelforum.com/showthread...hreadid=378389

Hey all !!! I DID IT !
One happy beginner today !
:) :) :) :) :) :)


--
giselle
------------------------------------------------------------------------
giselle's Profile: http://www.excelforum.com/member.php...o&userid=24222
View this thread: http://www.excelforum.com/showthread...hreadid=378389

Good for you! Congratulations. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Hey all !!! I DID IT !
One happy beginner today !
:) :) :) :) :) :)


--
giselle
------------------------------------------------------------------------
giselle's Profile: http://www.excelforum.com/member.php...o&userid=24222
View this thread: http://www.excelforum.com/showthread...hreadid=378389