adding scroll bars to a chart

[news2]

How do you add a scroll bar to a chart? I have the end of day stock close
over a 5 year period and I would like to scroll back and forth to see how
the stock changes over a 50 to 75 days.

 

[Guest]

Hi,

See "Funchart7.zip" under "Charting Examples" in "Steve Bullen's Excel
Page", http://oaltd.co.uk/Excel/

Regards,
B. R. Ramachandran

 

[Charles]

Thanks for help.

CC

Hi,

See "Funchart7.zip" under "Charting Examples" in "Steve Bullen's Excel
Page", http://oaltd.co.uk/Excel/

Regards,
B. R. Ramachandran

 

[Charles]

Hi,
The funchart is for embedded charts on a spreadsheet. I was wanting to have
a chart sheet with scroll bars at the bottom. Do you know if this is
possible.

Thanks

 

[Jon Peltier]

Charles -

It will work fine. Set it up the same way, with the chart on its own
sheet, and the scroll bars on the chart sheet. The cell links from the
scroll bars are on the worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______