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.
 
 
Search JabSto ::




Custom Search