ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   axis scaling (https://www.excelbanter.com/charts-charting-excel/195366-axis-scaling.html)

RJDII

axis scaling
 
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

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.





All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com