Re: 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

Thanks Debra. Gives me a few ideas!
"Debra Dalgleish" <dsd@contextures.com> wrote in message
news:3F7186EF.7070509@contextures.com...
> 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
>