Map one column to x axis second to y axis in excel chart
Map one column to x axis second to y axis in excel chart
Map one column to x axis second to y axis in excel chart
Re: Map one column to x axis second to y axis in excel chart
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.
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.