G Guest Aug 31, 2006 #1 How can I set the X and Y axis minimum and maximum values by reference to variable numbers in cells.
A Andy Pope Sep 1, 2006 #2 Hi, You have to use VBA code to do this. Jon Peltier has an explanation http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html And Tushar Mehta has an addin http://tushar-mehta.com/excel/software/autochart/index.html Cheers Andy
Hi, You have to use VBA code to do this. Jon Peltier has an explanation http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html And Tushar Mehta has an addin http://tushar-mehta.com/excel/software/autochart/index.html Cheers Andy
