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.
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.
Click "Chart" in the "Insert" menu.
Select a scatter plot and click "Next."
Highlight the first two rows as your data set and click "Next."
Modify your chart appearance from the options available and click "Next."
Highlight the area you want the chart to displace and click "Finish." The chart will now display the demand curve.
Repeat the steps using rows 3 and 4 to chart the supply curve.