How to Use Excel for Demand & Supply Curves

A company can track the supply and demand of its products using Microsoft Excel. The company needs to input data on the quantity sold and the price it sells for. This is done by using multiple locations with different prices or using hypothetical estimates on sales. A demand curve is downward sloping, so it starts high near the zero point and goes down as the quantity increases. The supply curve is upper-ward sloping, so it starts low at the zero point and goes up as the quantity increases.

...
You can make supply and demand curves with Excel.

Step

Write your data in Excel. In row 1, type the price you sold the product for. In row 2, type the quantity you sold. In row 3, type the price you sold the product for; in row 4, type the amount of supply you had.

Step

Click "Chart" in the "Insert" menu.

Step

Select a scatter plot and click "Next."

Step

Highlight the first two rows as your data set and click "Next."

Step

Modify your chart appearance from the options available and click "Next."

Step

Highlight the area you want the chart to displace and click "Finish." The chart will now display the demand curve.

Step

Repeat the steps using rows 3 and 4 to chart the supply curve.