Excel – Map one column to x axis second to y axis in excel chart

chartsmicrosoft excel

I'm struggling while trying to plot simple data into a simple chart in Excel (2010 beta).

My data is a very simple one:

Value    Year  
-----    ----
1        1900
5        1902
3        1912

etc. In the chart, I want year to be the X axis and the value to be the Y axis, and have a single line mapping the change in value over years.

When I select my data, Excel wants to map both at the same time, rather than plotting each pair as a point on the graph.

How the heck do you do this?

Best Answer

I don't understand quite. What kind of graph do you want ? This ?

To get this, choose your chart as a linear type (xy scatter group). After that go to select data, and select x and y values by hand from series 1. After that, fix up a little your x axis properties, so the year shows every year, and not every two or so ... Might want to fix up the default look of the graph too.

alt text