Lining Scale to Merged Cells

P

Phil Hageman

Is there a way to set the Y axis minimum and maximum using
a link to a merged cell range?

Example:

Cell Range M20:O29
Value entered 65%

Cell Range M15:O15
Value entered 115%


I want to be able to change the scale in the worksheet
without having to format the scale in the chart itself.
Would this be done with VBA in the worksheet module where
the chart is imbedded?

Thanks, Phil
 
A

Andy Pope

Hi Phil,

There is no in built way to do this. But have a look at Jon's page,
which also includes a reference to Tushar's Auto chart manager.

(http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html)

Phil said:
Is there a way to set the Y axis minimum and maximum using
a link to a merged cell range?

Example:

Cell Range M20:O29
Value entered 65%

Cell Range M15:O15
Value entered 115%


I want to be able to change the scale in the worksheet
without having to format the scale in the chart itself.
Would this be done with VBA in the worksheet module where
the chart is imbedded?

Thanks, Phil
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Top