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
|
|||
|
|||
REPOST - chart horz scroll
I posted this 3 days ago, but has yet to appear in newsgroup, so I'll try
again ... Hello I'd like to scale my line graph so it is wider than my screen width. To explain better, I design power lines. Picture a line consisting of 21 poles (20 spans of 150 meter each) going across undulating country. Now, rather than have all the spans on the one screen (which would be all jammed up) I'd like a horz scroll bar so user can maybe view first 5 spans and then across scroll for the rest. Something like that anyway. The chart is actually an x-y scatter chart on it's own sheet. Is there a way to incorporate a scroll bar? I had a fiddle but couldn't find a way : ( Thanks Graeme |
#2
|
|||
|
|||
REPOST - chart horz scroll
Stephen Bullen has a sample chart with scrolling on his web site. Under
'Charting Examples', download FunChrt7.zip http://www.bmsltd.co.uk/Excel/Default.htm Graeme wrote: I'd like to scale my line graph so it is wider than my screen width. To explain better, I design power lines. Picture a line consisting of 21 poles (20 spans of 150 meter each) going across undulating country. Now, rather than have all the spans on the one screen (which would be all jammed up) I'd like a horz scroll bar so user can maybe view first 5 spans and then across scroll for the rest. Something like that anyway. The chart is actually an x-y scatter chart on it's own sheet. Is there a way to incorporate a scroll bar? I had a fiddle but couldn't find a way : ( -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
REPOST - chart horz scroll
Thanks Debra. Gives me a few ideas!
"Debra Dalgleish" wrote in message ... Stephen Bullen has a sample chart with scrolling on his web site. Under 'Charting Examples', download FunChrt7.zip http://www.bmsltd.co.uk/Excel/Default.htm Graeme wrote: I'd like to scale my line graph so it is wider than my screen width. To explain better, I design power lines. Picture a line consisting of 21 poles (20 spans of 150 meter each) going across undulating country. Now, rather than have all the spans on the one screen (which would be all jammed up) I'd like a horz scroll bar so user can maybe view first 5 spans and then across scroll for the rest. Something like that anyway. The chart is actually an x-y scatter chart on it's own sheet. Is there a way to incorporate a scroll bar? I had a fiddle but couldn't find a way : ( -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|