How do I invert my X and Y axis?
I'm a student and need to rotate the fallowing (and similar) graphs as follows, and I don't feel like pirating excel at the moment, how do I do this in numbers?
I want to turn this:
Into this:
Question marked as
I'm not quite getting what you are doing but here are some ideas:
If you have a chart made already and want to swap X and Y,
- Click on the chart then click on the line (the series) in the chart.
- Go to the Format sidebar on the right and it will show you what column (or row or range) is being used for the X and Y data for that series.
- Click in the box for the X data.
- In the table, select the data you want to use for X. If it is an entire column, click on the column letter to select the entire column. Alternatively, you can type the range into the box or edit what is there.
- Either click the green checkmark or hit Enter to accept the selection. Don't just click off to the box or it will revert back.
- Repeat the last 3 steps for the Y data and Name.
That sounds like a lot but it is really only three steps if your chart has one series (change the X data, Y data, and Name).
If you have a chart all set up and formatted how you want it and you want to make more of them but with other data:
- Select the chart
- Copy
- Paste then arrange on the page where you want it.
- Change the series X and Y data and Name as detailed above.
If your chart has more than one series and they share the same X data, you only have to change X once. To avoid changing all the Y's and Names, can delete all but the first series on the new chart, change just that one, then add the other columns to the chart like you normally would. I think each series will retain any special formatting you had set up.
