Excel Forum



Excel Magic Trick 329: Frequency Polygon With 2 Or More Line


See how to create a Frequency Table. Then see how to calculate the midpoint of each category and make a Frequency Polygon with two or more lines (two or more data sets). See the functions SUMPRODUCT and COUNTIFS. See how to create a Line Chart and change the Source data. See how to fix the horizontal axis so that includes the correct values. Frequency Polygon Line Chart.





Got a Question? Ask it Here in the Forum.