Q:

How do you graph a supply and demand curve in Excel?

A:

Quick Answer

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.

Know More

Full Answer

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.

  1. Open a new spreadsheet in Excel
  2. In column A cell 1 put the word Price
  3. In column A cell 2 put Qs
  4. In column A cell 3 put Qd
  5. In column B cell 1 put 10
  6. In column B cell 2 put 200
  7. In column B cell 3 put 540
  8. In column C cell 1 put 20
  9. In column C cell 2 put 300
  10. In column C cell 3 put 480
  11. Add more data as needed
  12. Hover the mouse over the Insert tab in Chart group select Scatter and click the icon for Scatter with Straight lines.
  13. A chart will then appear with the Supply and Demand diagram
  14. It will automatically display the Price on the X-axis this will need to be changed. Put the Price on the Y-axis.
  15. To change the axis right click on the chart and click Select Data from the menu
  16. Make sure to highlight the first row, which is Qs
  17. Delete the data in the box that pops up for Series X and Series Y values
  18. Put the cursor in the Y value box and select the Price values
  19. Put the cursor in X values and highlight Qs
  20. Follow the steps to edit the data for Qd column this time
  21. Click OK and a chart will appear
Learn more about Software

Related Questions

  • Q:

    How do you wrap text in Excel?

    A:

    To wrap text within a cell in Microsoft Excel, first select the cells you want to alter. Select the Wrap Text option from the Alignment menu to enable the change. Finally, alter the settings to make the text visible in the cells you selected.

    Full Answer >
    Filed Under:
  • Q:

    What companies use Microsoft Excel?

    A:

    Accounting, marketing and management consultant firms commonly rely on Microsoft Excel to perform functions related to their industry of expertise, says Brad Zomick of SkilledUp. Investment banking and business intelligence analysts also use the program to amalgamate and scrutinize data. Microsoft Excel is a basic application included in the Microsoft Office Suite of desktop programs and is an extremely popular resource among a variety of business professionals.

    Full Answer >
    Filed Under:
  • Q:

    What is a demand curve?

    A:

    A demand curve is a graphical representation of the demand of a product based on its price. Demand curves are downward sloping, demonstrating the law of demand that states that the quantity of a product or service demanded moves in the opposite direction of its price.

    Full Answer >
    Filed Under:
  • Q:

    How do you use the less than or equal to function in Excel?

    A:

    The "less than or equal to" function in Microsoft Excel is denoted by the symbols "<=", with the lesser value on the left side of the equation. This function is known as a "comparison operator," and it can be used in a variety of equations, functions and tests in Microsoft Excel.

    Full Answer >
    Filed Under:

Explore