Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 ...... -- giselle ------------------------------------------------------------------------ giselle's Profile: http://www.excelforum.com/member.php...o&userid=24222 View this thread: http://www.excelforum.com/showthread...hreadid=378389 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Graph Axes | Excel Discussion (Misc queries) |