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.