Microsoft Office Tutorials and References

In Depth Information

**ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO**

Figure 87.
h

e label position has been adjusted.

Summary:
Excel restricts movement of objects on a chart to within the chart

boundaries in order to programmatically determine the height and width of a

data label. By itself, the code in this solution is not of much use, but the technique

illustrated could form the basis of a larger routine for programmatically examining

a series for overlapping data labels and staggering them, if required.

ADJUST XY CHART SCALING

FOR CORRECT ASPECT RATIO

Challenge: You want to adjust an XY (scatter) chart so that both axes have the

same scale per unit axis value. That is, you need to adjust the chart in Figure

88 so the square and a circle appear as shown in Figure 89.You want to adjust

an XY (scatter) chart so that both axes have the same scale per unit axis value.

That is, you need to adjust the chart in Figure 88 so the square and a circle

appear as shown in Figure 89.