View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Adjusting Y axis scale of a chart using a scrollbar?


If I follow you will need two scrollbars, to set the first and last values
in the zoomed section. All this can be done with dynamic named ranges to
define the X & Y values, and perhaps a pair of scrollbars to set the lower
and upper bounds. No code required. Post back if interested to try something
like this.

Regards,
Peter T

"Brad" wrote in message
...
Hi all,

I thought this would be relatively easy, but turns out the solution is
alluding me.

I would basically like to adjust the scale of my budget graph's Y axis
using
a scrollbar. My chart is a combination bar & line chart displaying
historic
area cost as bars and future forecast costs as a line. The trouble I have
is
a number of areas have a large actual / forecast cost while others are
relatively small. I would like to adjust the scale of the y axis
effectively
zooming in on these lower cost areas.

Any help provided would be greatly appreciated.

Ta
Brad