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.

Continue Reading

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 use Excel?

    A:

    You can use Microsoft Excel by entering your information, and then formatting it to create spreadsheets for organizational or analytical purposes. The program offers an assortment of models, formulas and tools to present and track data in a variety of ways.

    Full Answer >
    Filed Under:
  • Q:

    How do you create formulas in Excel?

    A:

    You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, subtract, multiply or divide cell values are entered directly in your worksheet, while more complex formulas are initiated in the Excel formula dialogue box.

    Full Answer >
    Filed Under:
  • Q:

    What does "not equal" do in Excel?

    A:

    The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is represented using the “less than” and “greater than” mathematical symbols as “<>”.

    Full Answer >
    Filed Under:
  • Q:

    What is the difference between Access and Excel?

    A:

    Microsoft Access is a database management program, while Microsoft Excel is a spreadsheet application. Someone can use these programs simultaneously to track business productivity and other factors.

    Full Answer >
    Filed Under:

Explore