Autoscaling on XY chart

  • Thread starter Thread starter Mangesh Yadav
  • Start date Start date
M

Mangesh Yadav

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?
 
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
 
Yes, thats true. But I remember vaguely that Tushar Mehta had suggested some
method quite some days back. I may be wrong, it could be for some other
chart type (and not XY).

Mangesh
 
The only option that comes to mind is an add-in that works 'behind the
scenes.' 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

Yes, thats true. But I remember vaguely that Tushar Mehta had suggested some
method quite some days back. I may be wrong, it could be for some other
chart type (and not XY).

Mangesh
Click to expand...
 
Hi Tushar,

Thanks for the response. I have already checked the addin on your link, and
I don't want to go that way.
I think what I was refering to was probably some other chart type. Anyway,
if I ever find it tou, will let you know.

Mangesh



Tushar Mehta said:
The only option that comes to mind is an add-in that works 'behind the
scenes.' 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
Click to expand...
 
Hi Tushar,

Thanks for the response. I have already checked the addin on your link, and
I don't want to go that way.
I think what I was refering to was probably some other chart type. Anyway,
if I ever find it tou, will let you know.

Mangesh
Click to expand...


The only other way I can think of is to create a "fake" data set that
only contains the data that fall within your boundaries and then let
the chart auto-scale options sort it out.

i.e. if you want the "x-axis" to be from 5 to 10 then you'd filter out
any data points where the x value was outside this range.
 
Hi Paolo,

Thanks for the response. Anyway, at the moment I am going ahead with the VBA
solution.

Mangesh
 
Back
Top