Excel 2007 : How do I reverse the plot of axis?

[VBlue]

I've got some values that I've rendered into a graph, however I want it plotted another way around, but reversing the row/column data makes it look completely nonsensical.

http://imageshack.us/photo/my-images/24/42216314.jpg/

I want those axes swapped so it's plotted the correct way, but reversing the row/columns does something else entirely:

http://imageshack.us/photo/my-images/830/25613395.jpg/

What should I do?

[Richard Buttrey]

Hi,

Rather than supply a picture please upload your workbook. People are understandably rarely keen to retype your data when you already have it. It's also easier to help if we can see your request in context.

Also show the result you expect to see so that we know where we're heading for.

Regards

[Andy Pope]

excel expects the first column to contain the x value and subsequent columns to be y values for series.

Swapping the axs means converting the 1 series per column into 1 series per row.

What you want is to use the first column as y values and 2nd column as x values. Easiest way is to alter you data layout. Other wise you will need to use the Select data dialog to alter the range used for x and y values.

[VBlue]

Ah I see, that worked! Thanks so much, exactly the orientation I needed.