How to Graph a Production Possibilities Frontier in Excel 2007
A few days ago I create a post named How to Graph a Production Possibilities Frontier in Excel 2003, and I thought it might be helpful to demonstrate the difference regarding How to Graph a Production Possibilities Frontier in Excel 2007.
NB: I also have a post on How to Graph Specialised Growth with Two Production Possibility Curves in Excel 2010.
As shown above, enter your production possibilities data for the two goods, and then go to the Insert tab where you will find chart options. Simply click Scatter to drop down sub-options, where you should select a graph with lines—unless you have many data points, in which case you may have enough points to see the relationship. When you click the sub-option, your chart will appear on the page.
At this point, you can configure your chart by giving titles, labels, axes, and the like. Click the chart object you created and a set of menus will appear menu to do this. I hope this helps.
Economics @ ITT 
[…] to create a Production Possibilities Frontier (Curve) in Excel 2003. The concept carries forward to creating a PPC in Excel 2007, […]
The explanation for Excel 2003 is fantastic, however 2007 does not have the wizard and this brief explanation does not describe how to correct this criss crossing graph to make a curved PPF. 😦
Tiatiana,
Excel 2007 is simpler than 2003. You may be working with bad data. Try to create a PPF using the sample data I use in the example. No correction should be necessary. Feel free to comment further.
Thank you so much- i was using the wrong type of graph. You helped me tremendously!
Very useful, much appreciate it
love it, but what about two PPFS?
[…] response to my post on How to Graph a Production Possibilities Frontier in Excel 2007 and Excel 2003, several people have asked how to chart two production possibilities curves, so I […]