Using Microsoft Excel, how do I make a chart using one set of data as the X-axis?

Suppose you have the following data in Microsoft Excel:

Column A is Year, and column B is Value. Suppose you want to make a chart with Year on the X-axis and Value on the Y-axis. Follow the steps below for your version of Excel to make a chart based on these data.

Excel 2010 and 2007

1. Highlight cells A1 to B10.
   
   
2. Click the Insert tab on the Ribbon.
   
   
3. In the "Charts" section, click the desired chart style and substyle. The chart will appear on the screen.
   
   
4. Under the "Chart Tools" heading, Design should already be selected. Click Select Data in the "Data" section of the Ribbon.
   
   
5. Under "Legend Entries (Series)", select Year, and then click Remove.
   
   
6. Under "Horizontal (Category) Axis Labels", click Edit. Select cells A2 to A10, and then click OK.
   
   
7. Make sure the chart looks the way you want it to, and then click OK.

Other versions of Excel

1. Highlight cells A1 to B10.
   
   
2. From the Insert menu, select Chart.
   
   
3. Select the chart type and subtype. Click Next.
   
   
4. Click the Series tab.
   
   
5. Under "Series", click Year, and then click Remove.
   
   
6. In the "Category (X) axis labels" area, click Selection.
   
   
7. Highlight cells A2 to A10, and then press Enter.
   
   
8. Verify that the chart looks the way you want it to, and then click Next.
   
   
9. Fill in the chart's title and axis labels, and then click Finish.

Comments/Questions/Corrections