How To Draw A Frequency Polygon In Excel

Answer

Paul wrote:

i am doing an assignment and need to place a frequency polygon on top of a histogram, how do you do this in excel 2007

Presumably, you already know how to create the data for the histogram and the histogram itself. [1]

To create the frequency polygon:

Right-click on the chart, then click on Select Data.
Click on Add.
For the Series Values, select the same range that you selected for histogram.
Click OK, then click OK again. That creates a second histogram side-by-side.
Right-click a bar of the second histogram, then click on Change Series Chart Type.
Click on XY (Scatter), then click on the subtype you want, probably "with Lines and Markers".
Click OK. Excel automagically connects the midpoints of the first histogram bars.
To change the size of the markers, if any, right-click the frequency polygon (curve), then click on Marker Options.
Select Built-In, and make the desired adjustments. Then click Close.

-----
[1] If you do not know how to create the histogram data and chart, you should provide a concrete example to help us help you. The best way is to upload an example Excel file (devoid of any private data) that demonstrates the problem to a file-sharing website.

Then post the "shared", "public" or "view-only" link (aka URL; http://...) in a response here. The following is a list of some free file-sharing websites; or use your own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFire: http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidShare: http://www.rapidshare.com

46 people found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.