How to Create a Supply and Demand Graph in Excel?

The ability to graph in excel is tremendously useful to visualize data and make things understand better. But sometimes graphing certain things can be difficult. One such thing is the law of supply and demand.

So, let’s look at how to create a supply and demand curve in excel.

What is the Law of Supply and Demand?

The law of supply and demand dictates the relationship between willingness to buy a product and selling a product at a certain price.

The law of supply and demand has a graph that is very popular in economics.

Let’s look at how to create a supply and demand curve in excel.

How to Create a Supply and Demand Graph in Excel?

Step#1 Create a Supply and Demand Table

Create-a-Supply-and-Demand-Table

Create a table like this with three columns. The first column being the price of the product, the second being the demand of the product, and the third one being the supply of the product.

Step#2 Creating the Supply and Demand Graph

Then select the three columns and from the “Inset” ribbon go to “Recommended Charts.” You will see a dialogue box.

From the dialogue box select a line chart and press ok.

Creating-the-Supply-and-Demand-Graph

You will see a graph, but the graph is quite not right.

Creating-the-Supply-and-Demand-Graph-2

The prices should be on the y axis and the product amount should be on the X axis. So, let’s fix that.

Step#3 Fixing the Axis of the Graph

First, from “Chart Design” go to “Select Data.”

Fixing-the-Axis-of-the-Grap-1

Then from the dialogue box, select the supply column and go to edit.

Fixing-the-Axis-of-the-Grap-2

Then from the dialogue box, define the series name by selecting the “Supply” cell, define x series by selecting the supply amounts and define y series by selecting the prices.

Fixing-the-Axis-of-the-Grap-3

Then similarly, press “Add” to add the demand chart.

Then from the dialogue box, define the series name by selecting the “Demand” cell, define x series by selecting the demand amounts and define y series by selecting the prices.

Fixing-the-Axis-of-the-Grap-4

And, voila you now know how to create a supply and demand graph in excel.

Fixing-the-Axis-of-the-Grap-5

But the graph doesn’t look beautiful, so let’s do some edits to bring the graph to the center.

First, select the horizontal axis and go to “Axis Options.” Then change the minimum bounds to 400 and maximum bounds to 850.

Fixing-the-Axis-of-the-Grap-6

And there you go the graph is centered.

Now, you know how to create a supply and demand curve in excel.

Conclusion

Supply and demand is a famous law of economics. Understanding its graph has now a bit easier as you know how to create a supply and demand curve in excel now.

Related Article:

Leave a Comment