Please see me my other Excel articles.
Histogram: Quickly Illustrate Relative Frequency
In my Relative Frequency Histogram article I demonstrated how to transform a histogram to show each category’s value in comparison to the grand total of all diagnosis.
In this article, I will show how to begin with a relative frequency histogram and replace the bars with a simple line, showing only the maximum value for each category.
By selecting my existing chart, I can change the current chart type from showing bars for the frequency histogram to showing only a line, touching the greatest value for each bar.
With this frequency polygon histogram, I can more quickly visualize the curve of the relative frequency values without requiring the full range of values of bars in a usual histogram.