How to Make a PPF Graph in Google Sheets

A Production Possibility Frontier (PPF) graph might sound like something straight out of an economics textbook, but it's one of the most practical tools for making smart business decisions. It gives you a clear, visual way to understand the trade-offs involved when you have limited resources - like time, money, or staff. This guide will walk you through exactly how to create and interpret your own PPF graph using Google Sheets.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Production Possibility Frontier (PPF)?

At its core, a PPF graph shows you the maximum possible combinations of two different products or outcomes you can achieve with a fixed set of resources. Think of it as a map of your production or work capacity. Every business, from a solo freelancer to a large corporation, faces scarcity. You can't do everything at once. You have an IT budget, a marketing budget, a specific number of developer hours, or a limited amount of raw materials. The PPF helps you see the true cost of choosing one path over another.

For example, imagine a marketing team with a fixed monthly budget of $10,000. They can spend it on two main activities: writing SEO-focused blog posts (which costs them in writer fees and time) or running pay-per-click (PPC) ad campaigns.

• If they spend the entire budget on blog posts, they might be able to produce 20 articles but run zero ad campaigns.
• If they spend the entire budget on PPC ads, they might get 500 leads but publish zero articles.
• If they split the budget, they could produce 10 articles and get 250 leads from ads.

Plotting these combinations on a graph creates the "frontier" or curve. Any point on this curve represents an efficient use of their full budget. Any point inside the curve means they aren't using their resources effectively (maybe they didn't spend the full budget). Any point outside the curve is currently unattainable with their existing budget.

Understanding this visual helps you grasp a vital concept: opportunity cost. The opportunity cost of writing one more blog post is the number of ad leads you have to give up to find the budget for it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step: How to Create a PPF Graph in Google Sheets

Let's build a PPF graph from scratch. For our example, we'll use a small craft bakery that can produce two items: custom cakes and dozens of cookies. They have a fixed amount of oven time and baker hours each day.

After figuring out their production capacity, they created a table showing the possible combinations they can produce in a single day.

Step 1: Set Up Your Data Table

First, you need to lay out your potential production combinations in a simple table. The relationship between the two goods is often inverse - as you produce more of one, you must produce less of the other. Our bakery’s data looks like this:

Notice how to gain 20 dozen cookies (going from A to B), they only give up 2 cakes. But to get the last 10 dozen cookies (going from E to F), they have to give up 8 cakes. This is called "increasing opportunity cost" and is what gives the PPF its classic bowed-out shape.

Open a new Google Sheet and enter the data for the two products. Just use the two columns for goods, you do not need the 'Possibility' column.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Insert the Chart

Highlight the data you just entered, including the headers ("Dozens of Cookies" and "Custom Cakes"). Then, go to the menu and click Insert > Chart. Google Sheets will likely suggest a chart type, but it might not be the correct one, so we’ll need to adjust it.

Step 3: Choose the "Scatter chart"

The Chart editor panel will appear on the right side of your screen. Under the 'Setup' tab, click on the dropdown menu under 'Chart type'. A PPF must accurately plot the (X,Y) coordinates of your data, so the best choice is a Scatter chart.

Once you select it, you’ll see the individual points plotted on the graph, each representing one of the production possibilities from your table.

Step 4: Customize Your Chart to Create the Curve

Now we just have a set of dots. To turn it into a proper PPF, we need to connect them with a smooth line representing the "frontier."

1. Stay in the Chart editor and click on the 'Customize' tab.
2. Expand the ‘Series’ section.
3. From here, you can format the data series. Check the box for 'Trendline'. This will add a line that connects your data points.
4. To create the classic bowed-out curve, change the 'Type' of trendline to 'Polynomial'. You can adjust the 'Polynomial Degree' to get a smoother curve that best fits your points, a degree of 2 or 3 usually works well.
5. You can also change the color, thickness, and style of the trendline here to make it stand out.

Step 5: Label Everything Clearly

A graph without labels is just a picture. You need to add context so anyone can understand it at a glance.

1. In the 'Customize' tab, go to the 'Chart & axis titles' section.
2. Under 'Chart title', give your graph a descriptive name, like "Bakery's Daily Production Possibility Frontier".
3. Next, use the dropdown to select 'Horizontal axis title' and label it with the name of your X-axis data - in this case, "Dozens of Cookies Produced".
4. Do the same for the 'Vertical axis title', labeling it "Custom Cakes Produced".
5. Adjust the fonts and font sizes as needed to make them easy to read.

How to Interpret Your PPF Graph

Your finished graph is more than just a nice-looking curve. It’s a tool for strategic decision-making. Here's what the different parts of the graph tell you:

• Points ON the Curve: Any point that falls directly on the swooping line (like points A-F from our table) represents a productive, efficient outcome. At these points, the bakery is using all its resources to their fullest potential. The choice between Point C (40 dozen cookies, 20 cakes) and Point D (60 dozen cookies, 15 cakes) is not about efficiency, but about strategy and what the market demands.
• Points INSIDE the Curve: Let's say one day the bakery only produces 40 dozen cookies and 10 cakes. Find that point on your graph (40 on the x-axis, 10 on the y-axis). You’ll see it sits well inside the curve. This is an inefficient point. It signals that resources were wasted - maybe a baker called in sick, or an oven was broken. They could have produced more of one good without sacrificing any of the other. The goal is always to move from an inefficient point towards the frontier line.
• Points OUTSIDE the Curve: What if the bakery owner sets a goal to produce 80 dozen cookies AND 20 cakes? If you plotted that point, it would float far outside the established curve. This is an unattainable goal with current resources. It demonstrates the constraints of the business. To reach this point, they would need a fundamental change, like buying a new oven, hiring another baker (increasing resources), or finding a new recipe that cuts baking time (improving technology).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Revealing Opportunity Cost

The shape of the curve itself tells a story. The slope between any two points shows the opportunity cost. Moving from Point B to Point C means gaining 20 dozen cookies (from 20 to 40) at the cost of 3 cakes (from 23 to 20). So the opportunity cost of each dozen cookies in that range is 3/20, or 0.15 cakes.

But moving from Point D to Point E, they gain another 20 dozen cookies (60 to 80), but this time it costs them 7 cakes (from 15 to 8). The opportunity cost per dozen cookies just jumped to 7/20, or 0.35 cakes. The cost of producing cookies (in terms of cakes) went up because the resources (staff, equipment) best suited for cake-making are now being reallocated to making cookies. This increasing opportunity cost is realistic for most businesses and is why the PPF bows outward.

Final Thoughts

Creating a Production Possibility Frontier graph in Google Sheets is a simple yet powerful way to translate abstract economic principles into concrete business strategy. It helps you visualize trade-offs, identify inefficiencies, and set achievable goals by showing you exactly what your operational limits are and the real cost of every choice you make.

While building these visual reports manually in Google Sheets provides powerful insights, we understand that marketing and sales teams often struggle to aggregate data from scattered sources like Google Analytics, Shopify, or Salesforce to perform this kind of analysis. At Graphed, we connect directly to all your data sources, allowing you to ask questions in plain English - like "Compare ad spend vs. revenue by campaign" - and instantly receive AI-generated dashboards. It's about turning hours of manual data wrangling and chart-building into a simple, 30-second conversation, so you can focus on making decisions, not pulling reports.