S Sandra Aug 24, 2004 #1 I want to set the minumum and maximum on a chart's X axis by reading values of two cells. Is this possible?
I want to set the minumum and maximum on a chart's X axis by reading values of two cells. Is this possible?
D Debra Dalgleish Aug 24, 2004 #2 Jon Peltier has instructions on his web site: http://www.peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
Jon Peltier has instructions on his web site: http://www.peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
T Tushar Mehta Aug 24, 2004 #3 Min. and max. axis values can be set from cell values only with VBA support. For a readymade solution see AutoChart Manager http://www.tushar-mehta.com/excel/software/autochart/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
Min. and max. axis values can be set from cell values only with VBA support. For a readymade solution see AutoChart Manager http://www.tushar-mehta.com/excel/software/autochart/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
