Lining Scale to Merged Cells

[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

 

[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)

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

--

Cheers
Andy

http://www.andypope.info