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

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

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