axis scaling

[RJDII]

I would like to set the min and max values of the y axis on a scatter chart
to be the value of a cell. Using excel 2003.

 

[Jon Peltier]

This is not native functionality in Excel, but you can make it happen with a
little VBA.

This article shows how:
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Tushar Mehta has a utility that handles it for you:
http://tushar-mehta.com/excel/software/autochart/index.html

- Jon