switch X and Y in scatter (XY) chart in 2008

[oboedoctor]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I need to switch the X with the Y axis in my scatter chart. This used to be as easy as clicking a "switch x and y" button when I had a pc, but now I can't figure out how to do it.

Any ideas?

 

[Eric Waldbaum [MSFT]]

With the chart selected, go to the Formatting Palette->Chart Data pane and
you could click the Sort by: Column instead of Row. If you click the
Edit... button there, then there is a "Switch Row/Column" button and you can
set X and Y values there. I hope this helps!

-Eric
MacOffice Testing
Microsoft