ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a frequency polygon in Excel? (https://www.excelbanter.com/charts-charting-excel/158224-how-do-i-create-frequency-polygon-excel.html)

Benny

How do I create a frequency polygon in Excel?
 
I am trying to create a frequency polygon using mid-point values for the
horizontal axis, and heights from a source.

Jon Peltier

How do I create a frequency polygon in Excel?
 
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
...
I am trying to create a frequency polygon using mid-point values for the
horizontal axis, and heights from a source.





All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com