So, I've got some data that I'd like to plot on an X-Y scatter graph. Unfortunately, X and Y are the wrong way round in the spreadsheet, so that when I plot the graph, Excel puts my Y values along the X axis and my X values up the Y axis.

Double unfortunately, I can't swap the columns in the source data -- the file's generated as CSV by another application.

How do I persuade Excel to plot the axes the other way round?

Can't you just change what cells it uses for each axis in the series tab? Right click the graph, select Source Data and then Series. There should be a field for X values and a field for Y values.

Using your control key, highlight column you want for x, release control key. Then highlight y, release control key - click on the graph button and there ya go!

Double unfortunately, I can't swap the columns in the source data -- the file's generated as CSV by another application.

awk -v FS=, -v OFS=, -- '{print $2, $1 }' < xy.csv > yx.csv

Peter

What he said, Just swap the chart's references around.

(edit: The apostrophy fell off, it's back now.)

tman: Can't you just change what cells it uses for each axis in the series tab? Right click the graph, select Source Data and then Series. There should be a field for X values and a field for Y values.

Excellent. That does exactly the right thing. Thanks.

PhilipOHare: Using your control key, highlight column you want for x, release control key. Then highlight y, release control key - click on the graph button and there ya go!

Doesn't work. At least not in Office XP.