There are three types of axes that the charting utility can display on a chart: a value axis, a category axis, and a date axis. Category axes have text labels identifying the category or series in the chart. Value axes display numbers as values or percentages. Date axes display a range of dates. It is important to know the type of axis you are dealing with in each chart type, because any appropriate formatting applied to an axis is maintained when you switch to a new chart type.
The following table provides a list of the types of each axis on various chart types.
Chart Types |
X |
Y |
2nd Y |
Z |
---|---|---|---|---|
2D Bar |
Category |
Value |
Value |
N/A |
2D Line |
|
|
|
|
2D Area |
|
|
|
|
2D Step |
|
|
|
|
2D Combination |
|
|
|
|
3D Bar |
Category |
Value |
Value |
Category |
3D Line |
|
|
|
|
3D Area |
|
|
|
|
3D Step |
|
|
|
|
3D Combination |
|
|
|
|
2D and 3D Horizontal Bar |
Category |
Value |
N/A |
N/A |
2D and 3D Gantt |
Category |
Date |
N/A |
N/A |
XY |
Value |
Value |
N/A |
N/A |
Bubble |
Value |
Value |
N/A |
N/A |
Hi-Lo |
Date or Category |
Value |
Value |
N/A |
Polar |
Angle |
Value |
N/A |
N/A |
Radar |
Radar |
Value |
N/A |
N/A |
3D Clustered Bar |
Category |
Value |
Value |
N/A |
3D XYZ |
Value |
Value |
Value |
N/A |
3D Scatter |
Value |
Value |
Value |
Value |
2D Contour |
Category |
N/A |
N/A |
Category |
3D Surface |
Category |
Value |
Value |
Category |
Related topics |