Hi,

Unfortunately you can not link the min/max of the scale to cells
directly. I think VBA is the only approach to dynamic updating of those
properties.

Cheers
Andy

Mangesh Yadav wrote:
Hi,

Is VBA the only solution to autoscale axis in an XY plot...? I would like to
set the min and max for my x-axis as my data changes. (I know how to do it
through VBA).

Or is there any other short-cut?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info