How Do You Graph a Supply and Demand Curve in Excel?
The best way to graph a supply and demand curve in Microsoft Excel would be to use the XY Scatter chart. A line graph is good when trying to find out a point where both sets of data intersects. A column chart is good for displaying the variation between the data.
To graph a supply and demand curve in Microsoft Excel in both versions 2010 and 2013, follow these steps. Replace the data used in the example below with the data that is available to you.
- Open a new spreadsheet in Excel
- In column A cell 1 put the word Price
- In column A cell 2 put Qs
- In column A cell 3 put Qd
- In column B cell 1 put 10
- In column B cell 2 put 200
- In column B cell 3 put 540
- In column C cell 1 put 20
- In column C cell 2 put 300
- In column C cell 3 put 480
- Add more data as needed
- Hover the mouse over the Insert tab in Chart group select Scatter and click the icon for Scatter with Straight lines.
- A chart will then appear with the Supply and Demand diagram It will automatically display the Price on the X-axis this will need to be changed. Put the Price on the Y-axis.
- To change the axis right click on the chart and click Select Data from the menu
- Make sure to highlight the first row, which is Qs
- Delete the data in the box that pops up for Series X and Series Y values
- Put the cursor in the Y value box and select the Price values
- Put the cursor in X values and highlight Qs
- Follow the steps to edit the data for Qd column this time
- Click OK and a chart will appear