Microsoft Office Tutorials and References
In Depth Information
Working with Chart Axes
Figure 7-19: These two charts show the same data, but they use different value axis scales.
If you’re preparing several charts that use similarly scaled data, keeping the scales constant across all
charts facilitates comparisons across charts. The charts in Figure 7-20 show the distribution of
responses for two survey questions. For the top chart, the value axis scale ranges from 0% to 50%.
For the bottom chart, the value axis scale extends from 0% to 35%. Because the same scale was not
used on the value axes, however, comparing the responses across survey items is difficult.
Figure 7-20: These charts use different scales on the value axis, making a comparison between the two difficult.