Click "Edit" in the "Horizontal (Category) Axis Labels" box. Select the cells in column A and click "OK." Click "OK" to close the dialog box. The chart now correctly tracks your data.

Grids have two axes. The horizontal axis is called the x-axis and the vertical axis is called the y-axis. Coordinates are always written like this (2, 3).

Enable Chart Tool options by clicking anywhere within an Excel 2007 or 2010 chart whose information you want to modify. Click Design on the main menu, then Layout and finally, select Axis Title or ...

We discuss a comment on a previous post stating that the text of labels on the vertical axis of graphs must be horizontal by discussing the pros and cons of four possible positions for these labels.