Then similarly, press “Add” to add the demand chart. 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.

Then from the dialogue box, select the supply column and go to edit. Step#3 Fixing the Axis of the Graphįirst, from “Chart Design” go to “Select Data.” The prices should be on the y axis and the product amount should be on the X axis. You will see a graph, but the graph is quite not right. Then select the three columns and from the “Inset” ribbon go to “Recommended Charts.” You will see a dialogue box.įrom the dialogue box select a line chart and press ok. Step#2 Creating the Supply and Demand Graph 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. How to Create a Supply and Demand Graph in Excel? Step#1 Create a Supply and Demand TableĬreate a table like this with three columns. Let’s look at how to create a supply and demand curve in excel. The law of supply and demand has a graph that is very popular in economics. The law of supply and demand dictates the relationship between willingness to buy a product and selling a product at a certain price. So, let’s look at how to create a supply and demand curve in excel. One such thing is the law of supply and demand. But sometimes graphing certain things can be difficult. The ability to graph in excel is tremendously useful to visualize data and make things understand better.

How to plot a graph in excel