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/...nkToSheet.html
Tushar Mehta has a utility that handles it for you:
http://tushar-mehta.com/excel/softwa...art/index.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"RJDII" wrote in message
...
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.