How do I Create a Polygon Frequency for Three Sets of Data Using Excel 2007?

A frequency polygon--a graph of a frequency table--can be helpful in comparing sets of data and can help you visualize how the sets of data compare against each other. For example, contrast data from sales over the prior three years or compare three salespeople's performances on one chart. Graph a frequency polygon in Microsoft Excel using the built-in chart tool.

Things You'll Need

  • Excel 2007
Show More

Instructions

    • 1

      Open Excel by double-clicking on the Desktop icon or by clicking on the "Start" or "Microsoft Office" buttons, then clicking "All Programs" > "Microsoft Office." Click on "Microsoft Excel." Excel will open with a new spreadsheet.

    • 2

      Type your data into the Excel spreadsheet. For example, if you want to plot sales data for the last three years, place the data from year 1 into column A, the sales data from year 2 into column B, and the sales data from year 3 into column C.

    • 3

      Highlight the three columns of data by left clicking on the top left of the data, then dragging the cursor to the bottom right.

    • 4

      Click on the "Insert" tab, then click "Line." Click on the first line graph icon. Excel will insert the frequency polygon into your spreadsheet.

Learnify Hub © www.0685.com All Rights Reserved