# Excel help - Grahping Economic functions **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [November 16, 2009, 12:21pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184 "2009-11-16T12:21:09Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 16, 2009, 12:21pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/1 "2009-11-16T12:21:09Z")
For part of my micro economics final project I have to graph certain functions from a companies financial statements over a few years. I chose Honda 03-09. I cant get the graphs to turn out the way they should; with price on the y-axis, and quantity on the x-axis. I have everything calculated out in excel. any ideas? I can email the spreadsheet to someone if they want to mess with it. (everything is in thousands, btw) ![http://nyspeed.com/forums/attachment.php?attachmentid=11063&stc=1&d=1258402842](http://nyspeed.com/forums/attachment.php?attachmentid=11063&stc=1&d=1258402842) it should look something like this: ![http://mba651fall2007.wikispaces.com/file/view/AVC_Graph_3.png/31507453](http://mba651fall2007.wikispaces.com/file/view/AVC_Graph_3.png/31507453) ---
**Author:** ![newman](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/newman/32/7569_2.png) [@newman](https://forums.speedlife.net/u/newman)\ **Post date:** [November 16, 2009, 12:23pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/2 "2009-11-16T12:23:56Z")
[ctnewman@gmail.com](mailto:ctnewman@gmail.com) though you already did the hard part… ---
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 17, 2009, 10:18am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/3 "2009-11-17T10:18:15Z")
good try newman. lol here is what I got by breaking up the data. I still cant figure out how to get the quantity on the x axis and have the corresponding lines plot correctly. ![http://nyspeed.com/forums/attachment.php?attachmentid=11076&stc=1&d=1258481783](http://nyspeed.com/forums/attachment.php?attachmentid=11076&stc=1&d=1258481783) ![http://nyspeed.com/forums/attachment.php?attachmentid=11077&stc=1&d=1258481783](http://nyspeed.com/forums/attachment.php?attachmentid=11077&stc=1&d=1258481783) ---
**Author:** ![ubengineering](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ubengineering/32/5171_2.png) [@ubengineering](https://forums.speedlife.net/u/ubengineering)\ **Post date:** [November 17, 2009, 10:23am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/4 "2009-11-17T10:23:37Z")
so theyre just linear plots? i dont understand whats keeping them from plotting correctly if the x and ys are all in the right place, also i hate the new excel ---
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 17, 2009, 11:13am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/5 "2009-11-17T11:13:03Z")
well technically its not an (x,y) plot. for example: at 15,120 units (x-axis) with a price of $4,386.18 (y-axis) yields 66,319,000 in total revenue (point to be plotted). ---
**Author:** ![Fry](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fry/32/7284_2.png) [@Fry](https://forums.speedlife.net/u/Fry)\ **Post date:** [November 17, 2009, 11:31am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/6 "2009-11-17T11:31:36Z")
So it’s 3 dimensional? ---
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 17, 2009, 1:04pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/7 "2009-11-17T13:04:15Z")
it better not be, this is micro economics 101. Ill try to get more clairification in class tomorrow. This is a lot more than he is expecting, most of the kids in this class are freshman and he said its ok to draw it by hand. Regardless, I still want to know how to do it. ---
**Author:** ![newman](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/newman/32/7569_2.png) [@newman](https://forums.speedlife.net/u/newman)\ **Post date:** [November 17, 2009, 1:26pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/8 "2009-11-17T13:26:52Z")
Dude, i’m telling you a 2d graph can only be a function of 1 variable. If you have 2 variables, time and price, you need a 3d graph. You said wanted quantity on the X and dollars on the Y, but in economics, Q is TIME not quantity. However, you can have Y(x) = X, q where Q is also a function of x, or a SCALAR ---
**Author:** ![walter](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/walter/32/7202_2.png) [@walter](https://forums.speedlife.net/u/walter)\ **Post date:** [November 17, 2009, 1:34pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/9 "2009-11-17T13:34:34Z")
> [@newman](#): > > Dude, i’m telling you a 2d graph can only be a function of 1 variable. > > If you have 2 variables, time and price, you need a 3d graph. > > You said wanted quantity on the X and dollars on the Y, but in economics, Q is TIME not quantity. > > However, you can have Y(x) = X, q > > where Q is also a function of x, or a SCALAR this Although from the look of the attachment, it just looks like he is trying to have them all plotted against individual Y axises. Easy with two variables (think dyno plot of HP/tq) but I’m not sure how to do it with more than that in Excel. ---
**Author:** ![newman](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/newman/32/7569_2.png) [@newman](https://forums.speedlife.net/u/newman)\ **Post date:** [November 17, 2009, 1:46pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/10 "2009-11-17T13:46:05Z")
Yeah, but everything he seems to want to plot is time vs dollars… it’s going to get ugly if you’re trying to associate 3 different Y axes of dollars to 3 different curves… For that I would scale the input data and note it in the legend MC^-3 or something… ---
**Author:** ![newman](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/newman/32/7569_2.png) [@newman](https://forums.speedlife.net/u/newman)\ **Post date:** [November 17, 2009, 1:51pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/11 "2009-11-17T13:51:36Z")
What I think he’s missing about adding the QUANTITY is that his FUNCTION for each plotted curve is dependent on quantity, so that’s where it picks it up. ---
**Author:** ![walter](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/walter/32/7202_2.png) [@walter](https://forums.speedlife.net/u/walter)\ **Post date:** [November 17, 2009, 1:52pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/12 "2009-11-17T13:52:03Z")
Yea, you can fudge the numbers by scaling them and then hiding the Y-axis labels in order to get the “look” that you seem to be going for. ---
**Author:** ![ubengineering](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ubengineering/32/5171_2.png) [@ubengineering](https://forums.speedlife.net/u/ubengineering)\ **Post date:** [November 17, 2009, 6:19pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/13 "2009-11-17T18:19:32Z")
if you get real desperate, in my mae334 class, i got lazy and didnt do my last lab, i used paint an made all the figures 93/100 =) ---
**Author:** ![joyride2k](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/joyride2k/32/7289_2.png) [@joyride2k](https://forums.speedlife.net/u/joyride2k)\ **Post date:** [November 17, 2009, 6:46pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/14 "2009-11-17T18:46:36Z")
![http://www.nyspeed.com/forums/attachment.php?attachmentid=11090&d=1258512334](http://www.nyspeed.com/forums/attachment.php?attachmentid=11090&d=1258512334) is this what you’re trying to do? ---
**Author:** ![chino](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@chino](https://forums.speedlife.net/u/chino)\ **Post date:** [November 17, 2009, 6:50pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/15 "2009-11-17T18:50:33Z")
> [@walter](#): > > this > > Although from the look of the attachment, it just looks like he is trying to have them all plotted against individual Y axises. Easy with two variables (think dyno plot of HP/tq) but I’m not sure how to do it with more than that in Excel. a dual axis graph. one axis on the left one on the right ---
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 17, 2009, 7:57pm UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/16 "2009-11-17T19:57:22Z")
> [@joyride2k](#): > > is this what you’re trying to do? thats the same graph as I did above, but you selected the line segment instead of a curve > [@chino](#): > > a dual axis graph. > > one axis on the left one on the right ok, now we are getting some where… ---
**Author:** ![newman](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/newman/32/7569_2.png) [@newman](https://forums.speedlife.net/u/newman)\ **Post date:** [November 18, 2009, 5:35am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/17 "2009-11-18T05:35:53Z")
> [@travisn](#): > > thats the same graph as I did above, but you selected the line segment instead of a curve No, it’s actually totally different… That is units vs. dollars Yours is time vs. dollars. ---
**Author:** ![newman](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/newman/32/7569_2.png) [@newman](https://forums.speedlife.net/u/newman)\ **Post date:** [November 18, 2009, 5:37am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/18 "2009-11-18T05:37:49Z")
> [@travisn](#): > > ok, now we are getting some where… On a dual axis graph you are still only able to plot ONE variable… It’s like making: a quantity vs dollars graph a time vs. dollars graph and laying them over the top of one another… is that what you want to do? ---
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 18, 2009, 5:52am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/19 "2009-11-18T05:52:14Z")
> [@newman](#): > > No, it’s actually totally different… > > That is units vs. dollars > > Yours is time vs. dollars. no, its the same graph, he just incorrectly re-labeled the x axis. his: mine: nice try, it probably would have gone un noticed in a paper. lol ---
**Author:** ![travisn](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/travisn/32/5046_2.png) [@travisn](https://forums.speedlife.net/u/travisn)\ **Post date:** [November 18, 2009, 8:06am UTC](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184/20 "2009-11-18T08:06:00Z")
The graph I posted originally is right. my economics professor (brewer, taught at UB for a while, anyone know him?) said that all of the functions in the bigger graph have a common denominator of output (quantity), so they are already in respect to quantity. [Next page](https://forums.speedlife.net/t/excel-help-grahping-economic-functions/76184.md?page=2)