Swap X and Y axes on Numbers 3.1

graphiworknumbers

This link is now outdated with the new release of numbers.

I want to transpose the X- and Y-axes on a chart in Numbers 3.1. How the heck can I do this?

The first chart I made was able to sum my columns up to 100 just fine:
Correct display

However, when I try it with fewer columns/geographies, it transposes the selection:
Incorrect display

Even when I transpose the cells, it still forces the data to display incorrectly and there is no option to swap the axes:
Still incorrect display

I'm so frustrated with this! How can I make it plot correctly? Thanks!

Best Answer

Was having the same problem – apparently the options to swap axes moved to the bottom left when Editing Data References:

options

Answer found here.