Microsoft Office Tutorials and References
In Depth Information
Value Axis versus Category Axis
Figure 4-19: The category labels have been replaced with numbers — but the
numbers do not function as numbers.
Two of Excel’s chart types are different from the other chart types in one
important respect. XY charts and bubble charts use two value axes. For these chart types,
both axes represent numeric scales.
Figure 4-20 shows two charts (an XY chart and a line chart) that use the same
data. The data shows world population estimates for various years. Note that the
interval between the years is not consistent.
Figure 4-20: These charts plot the same data but present very different pictures.