Economics @ ITT

How to Graph a Production Possibilities Frontier in Excel 2007

Posted in economics, microeconomics, tutorial by ittecon on March 14, 2010

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.

Excel 2007 PPC Image

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.

About these ads

7 Responses

Subscribe to comments with RSS.

  1. [...] to create a Production Possibilities Frontier (Curve) in Excel 2003. The concept carries forward to creating a PPC in Excel 2007, [...]

  2. Tatiana said, on May 4, 2010 at 3:04 am

    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. :(

  3. ittecon said, on May 4, 2010 at 11:48 am

    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.

  4. tamara jones said, on August 13, 2012 at 6:40 am

    Thank you so much- i was using the wrong type of graph. You helped me tremendously!

  5. malqershi@gmail.com said, on November 15, 2012 at 11:45 am

    Very useful, much appreciate it

  6. Goldmember said, on April 27, 2013 at 11:12 pm

    love it, but what about two PPFS?

  7. […] 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 […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 59 other followers

%d bloggers like this: