B
billinr
2 questions:
1.) I have a chart which plots circles in an X Y scatter. Based on the size
of the circles within the chart, the circles appear as an ellipse.
I can resize the chart manually to bring the circles back to shape - I was
wondering if there was some quick VBA to make the chart area relative to the
X and Y axis length.
2.) I use these charts as a template, so the data changes. If I know the
extreme X and Y values, is there a method to control the axis length with
that information - while still taking advantage of the "automatic" scaling
feature? (this will be incorporated into the above question)
Thanks in advance for the consideration.
1.) I have a chart which plots circles in an X Y scatter. Based on the size
of the circles within the chart, the circles appear as an ellipse.
I can resize the chart manually to bring the circles back to shape - I was
wondering if there was some quick VBA to make the chart area relative to the
X and Y axis length.
2.) I use these charts as a template, so the data changes. If I know the
extreme X and Y values, is there a method to control the axis length with
that information - while still taking advantage of the "automatic" scaling
feature? (this will be incorporated into the above question)
Thanks in advance for the consideration.