How to Graph Specialised Growth with Two Production Possibility Curves


Economics @ ITT

In 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 have created the amendment for Excel 2010, which is substantially similar to Excel 2007, and the concepts still apply to Excel 2003, though the mechanics are different. Some texts reference these curves as PPC, PPF, or PPFC. No matter, they all server the same function, which is to graphically represent opportunity costs.

From the Insert menu, select Scatter, and choose the one with smooth lines and markers—unless you do not want markers.

The key is simply add the second item to be represented on the Y-axis; otherwise follow the same steps for a single curve,

PPC - Specialised Growth

The resultant chart will appear like this:

PPC - Specialised Growth Chart

If you wish the specialisation to appear on the X-axis instead of the Y-axis, simply reverse…

View original post 36 more words