adding scroll bar to a chart

[alldreams]

Hi MVPs,

What would required to add a scroll bar to a chart object
in a sheet so the user can simply scroll to the right and
left to see the range in a chart?

Your help is greatly appreciated.

 

[Tom Ogilvy]

do you mean to change the range plotted on the chart?

 

[alldreams]

the scroll bar would allow me to see the date range in
the chart

 

[Tom Ogilvy]

scrollbar is used to change something. "see the date range in the chart" -
look at the axis labels that have dates.

 

[Guest]

axil labels show the dates, but what if the date I want
is not showing? I want to set the data range from data a
to date z and I want the scrollbar to help viewing the
ranges

 

[Tom Ogilvy]

so add a scrollbar from the forms toolbar.

in the onaction macro, translate the scrollbar value to increment or
decrement the maximumscale or minimumscale value of the appropriate axis.

 

[Gord Dibben]

See Stephen Bullen's FUNCHRT7.xls for adding scroll bars to change the range
of data on a chart.

Can be downloaded as a *.ZIP file.

http://www.bmsltd.ie/Excel/Default.htm

Gord Dibben Excel MVP

 

[Jon Peltier]

In this article, I have an example using scrollbars to change the axis
range:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon