Microsoft Office Tutorials and References
In Depth Information
Working with Chart Axes
Figure 7-28: The category axis contains labels from three columns.
When this chart was created, range A1:E10 was selected. Excel determined automatically that the first
three columns would be used for the category axis labels.
This type of data layout is common when you work with pivot table, and pivot charts
often use multiline category axes.
To remove an axis is to select it and then press Delete.
Figure 7-29 shows three charts with no axes displayed. Using data labels makes the value axis
superfluous, and it is assumed that the reader understands what the horizontal axis represents.
Figure 7-29: Three line charts with no axes.