Axis dates pulled from a cell

[Sandra]

I want to set the minumum and maximum on a chart's X axis by reading values
of two cells. Is this possible?

 

[Debra Dalgleish]

Jon Peltier has instructions on his web site:

http://www.peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

 

[Tushar Mehta]

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