Lining Scale to Merged Cells

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
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
 
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
 
Back
Top