Results 1 to 3 of 3

Supply and Demand Curve

This is a discussion on Supply and Demand Curve within the Excel Questions forums, part of the Question Forums category; Hi, Does anyone know how to chart a supply and demand curve in Excel 2010? I know this is probably ...

  1. #1
    New Member
    Join Date
    Feb 2011
    Posts
    1

    Default Supply and Demand Curve

    Hi,

    Does anyone know how to chart a supply and demand curve in Excel 2010? I know this is probably pretty basic but I'm lost.

    Thanks,

  2. #2
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,167

    Default Re: Supply and Demand Curve

    1) Use an X-Y chart (I think) - more control over x and y point.

    2) Plot a few points in a data grid

    3) charts always need tweaking until they look right. If you have many data points you can use a trend line, perhaps.

    More on charts:
    http://peltiertech.com/Excel/Charts/


    Sample Demand Curve:
    (note: the headers for Qty and Price are in B10 and C10,
    the qty data values are in $B11$:$B$15 and price data values are in $C$11:$C$15)
    chart

    These are chart options for the above scatter (xy) chart:
    chart

    Good luck!
    ξ

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  3. #3
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,167

    Default Re: Supply and Demand Curve

    Okay, with both curves in one chart.
    You can see the coordinates better in the picture. Here's the file if you like: Sample File (zip)

    Sample Demand Curve:
    chart

    These are chart options for the above scatter (xy) chart:
    chart


    ξ

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com