How do I create a frequency polygon in Excel?

Discussion in 'Microsoft Excel Charting' started by Guest, Sep 13, 2007.

  1. Guest

    Guest Guest

    I am trying to create a frequency polygon using mid-point values for the
    horizontal axis, and heights from a source.
     
    Guest, Sep 13, 2007
    #1
    1. Advertisements

  2. Guest

    Jon Peltier Guest

    Put your midpoint values in a column, and the corresponding heights in the
    next column. Select this data and create an XY chart, using one of the
    options with connecting lines between points.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    Peltier Technical Services, Inc. - http://PeltierTech.com
    _______


    "Benny" <> wrote in message
    news:...
    >I am trying to create a frequency polygon using mid-point values for the
    > horizontal axis, and heights from a source.
     
    Jon Peltier, Sep 14, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    frequency polygon help!!

    Guest, Jan 5, 2004, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    954
    Jon Peltier
    Jan 15, 2004
  2. jeanne

    frequency distribution and percentage frequency

    jeanne, Jan 13, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    3,387
    Mike Middleton
    Jan 13, 2004
  3. Guest
    Replies:
    4
    Views:
    2,984
    Jerry W. Lewis
    Aug 16, 2004
  4. Guest

    Displaying frequency polygons in Excel (Statistics)

    Guest, Jan 17, 2005, in forum: Microsoft Excel Charting
    Replies:
    3
    Views:
    995
    Michael R Middleton
    Jan 17, 2005
  5. Guest

    Frequency for Histograms in Excel

    Guest, Feb 22, 2005, in forum: Microsoft Excel Charting
    Replies:
    7
    Views:
    751
    Guest
    Feb 24, 2005
  6. Guest

    How Do I create a table in excel that shows frequency?

    Guest, Feb 8, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    475
    Bernard Liengme
    Feb 9, 2006
  7. Guest

    How do I create a polygon graph for statistics?

    Guest, Oct 20, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    752
    Mike Middleton
    Oct 20, 2006
  8. Bassman1514

    How do I create a Cumulative Frequency Histogram on Excel?

    Bassman1514, Jul 4, 2009, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    18,557
    Bernard Liengme
    Jul 4, 2009
Loading...