Adjusting scale of an adjsuting chart

S

sunil.koul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top