adding scroll bar to a chart

  • Thread starter Thread starter alldreams
  • Start date Start date
A

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.
 
scrollbar is used to change something. "see the date range in the chart" -
look at the axis labels that have dates.
 
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
 
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.
 
Back
Top