3

I'm taking an economics course, and for whatever reason economists create graphs with the independent variable (price) on the Y axis and not the X axis. If I only have 1 dependent variable to graph, it's pretty easy just to swap the two, but I need to create a graph with price as the independent variable on the Y axis with multiple dependent variables on the X axis. Is this possible in Numbers?

alt text

5
  • Can you be a little bit more specific? I’m not an Economics expert :) Dec 1, 2010 at 20:00
  • @Martín Typically when you graph something you'd put your independent variable, or the thing that changes, on the X axis, and the result of that change to the other variable, the dependent variable, on the Y axis. For example, if you wanted to graph population vs time, you'd put time on the X axis and population on the Y axis. Economists, unfortunately, have swapped this around and put price on the Y axis and the effect of that price on the X axis, but I can't find a way for Numbers to graph it that way. Dec 1, 2010 at 22:18
  • thanks for the info :) Now… back to your graphic, you’d want to have the price be on the Y and the “four columns” on the X? Dec 2, 2010 at 1:17
  • @Martín yes, exactly Dec 2, 2010 at 1:26
  • In Numbers version 10 you can use Table > Transpose Rows and Columns Feb 26, 2021 at 21:51

2 Answers 2

2

I’ve noticed a button you don’t have. What version of Numbers do you have? (I have 09)

Look at this:

alt text

That swaps the columns in the graph (exactly like you describe). I’m not really very good at Numbers.

Do you have that? One thing I’ve done, is used the price as a “column” but maybe that’s why you don’t have it?

My graphic looks awesome (sarcasm)…

(btw I hadn’t saved it and had to do it again)

alt text

6
  • I have '09 as well. Can you post the graph you've produced? Dec 2, 2010 at 1:51
  • Hm, that's not really the graph I had in mind. Thanks for trying, though I suspect that Numbers just isn't capable of what I need. Dec 2, 2010 at 2:56
  • @Kyle Thank god that’s not what you were looking for :) If you try to tell me what value should be on the lines… maybe I can keep trying. I’ve saved it this time :) Dec 2, 2010 at 3:04
  • @Martín something like this, only with the stuff labeled properly Dec 2, 2010 at 3:08
  • @Kyle I’ll see if I can come up with something tomorrow. Sry bout that. Dec 2, 2010 at 3:51
1

You can build your own transpose function using the index command:

enter image description here

The transpose cells all contain this: enter image description here

1
  • Welcome to Ask Different! Answers on Ask Different should be more than just a link. It's okay to include a link, but please summarize or excerpt it in the answer. The idea is to make the answer stand alone. Please take a look at the FAQs for more info. Thanks. Dec 16, 2011 at 23:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .