HOW TO PLOT DEMAND AND SUPPLY CURVE IN EXCEL?

If we have a simple demand schedule and supply schedule, how do we plot it in excel?

I will be explaining this step-by-step with the help of a video.

The demand and supply schedule are not clear in the video so I have created one for your understanding.

PRICE IN DOLLARS	QUANTITY DEMANDED	QUANTITY SUPPLIED
4	135	24
5	104	52
6	81	81
7	68	93
8	53	110
9	39	121

1. First highlight the columns of price, quantity demanded and quantity supplied 
2. Click on "Insert" tab and click on Scatter graphs
3. Choose smooth scatter graph or scatter with straight lines
4. When you do this the price will not be on the y-axis. To fix that click on the right click on the graph. Then click on select data
5. Select quantity demanded and click edit
6. When you do that a box will appear which has three text boxes. In the first text box write quantity demanded
7. In the second text box which asks you about the x values, highlight the quantity demanded column
8. In the third text box which asks you about the y values, highlight the price column
9. Repeat the above three steps for supply
10. Now you will have price on x-axis and quantity on y-axis
11. The supply and demand curve will intersect at a point which is your equilibrium point