Hi All Excel-VBA Experts,

I want to write a macro which would automatically adjust the Y-axis of
an excel chart depending on the data range..

Basically I have a chart pointing to a data range. The data range
often changes but the chart doesn't rescale itself to adjust for the
maximum resolution .. The excel auto option doesn't seem to be that
effective..

One way i could think of was to scan for the min & max values in the
data range but dont know how to adjust the chart axes then...

Any help would be greatly appreciated.
Thanks.
-Sunil

Hi

see in the PDF file (sample chapter) of chapter 15 of

Professional Excel Development

Written by Stephen Bullen, Rob Bovey and John Green

http://www.oaltd.co.uk/ProExcelDev/Default.htm

It's on one of the last pages, if I recall well. Nice stuff, I use it too in
one of my private Excel files.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


" wrote:

Hi All Excel-VBA Experts,

I want to write a macro which would automatically adjust the Y-axis of
an excel chart depending on the data range..

Basically I have a chart pointing to a data range. The data range
often changes but the chart doesn't rescale itself to adjust for the
maximum resolution .. The excel auto option doesn't seem to be that
effective..

One way i could think of was to scan for the min & max values in the
data range but dont know how to adjust the chart axes then...

Any help would be greatly appreciated.
Thanks.
-Sunil