Microsoft Office Tutorials and References
In Depth Information
You can change which data Excel applies to the vertical axis (also known as the y-axis )
and the horizontal axis (also known as the x-axis ). To make that change, select the
chart and then, on the Design tab, in the Data group, click Select Data to display
the Select Data Source dialog box.
The Year column doesn’t belong in the Legend Entries (Series) pane, which corresponds
to a column chart’s vertical axis. To remove a column from an axis, select the column’s
name, and then click Remove. To add the column to the Horizontal (Category) Axis
Labels pane, click that pane’s Edit button to display the Axis Labels dialog box.
In the Axis Labels dialog box, click the Collapse Dialog button at the right edge of the
Axis Label Range field, select the cells to provide the values for the horizontal axis (not
including the column header, if any), click the Expand Dialog button, and then click OK.
Click OK again to close the Select Data Source dialog box and revise your chart.