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
|