Excel: Chart – Histogram (Frequency Polygon)

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s