Help!! - Switch Data for X and Y Axes
This is probably ridiculously easy, but I can't seem to find what I'm looking for.
I have a table with about twelve columns. I am trying to make a scatter plot from two of them. However, the column I want for the x axis is on the right in the table, and the column for the y axis is on its left. So Numbers (being smart and following convention) takes the left column for the x axis. I know I could just rearrange the column order, but that would throw off the organization scheme I need for my table.
Is there any way for me to do what I want easily, or do I just have to make a little new table with those two columns in the correct order?
I have a table with about twelve columns. I am trying to make a scatter plot from two of them. However, the column I want for the x axis is on the right in the table, and the column for the y axis is on its left. So Numbers (being smart and following convention) takes the left column for the x axis. I know I could just rearrange the column order, but that would throw off the organization scheme I need for my table.
Is there any way for me to do what I want easily, or do I just have to make a little new table with those two columns in the correct order?
MacBook Pro, MacBook, Mac OS X (10.5.6)
