How to easily switch x and y axis in Excel for Mac 2011

[led84]

All, please can you help? I've just moved to using excel for mac 2011, and I am working with charts. When I build a chart excel for mac seems to default to having the largest scale numbers as the y axis, regardless of what column order I build the chart with. I need to swap the x and y axis in order to demonstrate the relationship more clearly. On the PC version there is a simple 'switch x/y axis' button but I cannot seem to find the equivalent on the mac version. Can anyone help me locate it and/or tell me an alternative method for switching the axis if this is not possible?

Thanks,

Laura

 

[Alba65]

Right click any axis and choose "select data" you can then change/swap axis or specify source data.