R RJDII Jul 17, 2008 #1 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.
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.
J Jon Peltier Jul 17, 2008 #2 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
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
