Thread: axis scaling
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default axis scaling

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.