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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    frequency polygon help!!

    Guest, Jan 5, 2004, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    776
    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,109
    Mike Middleton
    Jan 13, 2004
  3. Guest
    Replies:
    4
    Views:
    2,644
    Jerry W. Lewis
    Aug 16, 2004
  4. Guest

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

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

    How do I create a polygon graph for statistics?

    Guest, Oct 20, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    604
    Mike Middleton
    Oct 20, 2006
Loading...

Share This Page