frequency polygon help!!

G

Guest

please can someone help me??
i need to create a frequency polygon for some data i have........its very important so if anyone can help then pleeeease reply!!
i have managed to do the bar chart bit but i want to put the line graph bit on top of it.
please help
milly
 
J

Jon Peltier

Hi Milly -

I'm not sure what a frequency polygon is. But if you want a combination
column chart and line chart, plot all your data as a column chart, then
right click on the series you want to change to a line chart, choose
Chart Type from the pop up menu, and select the line chart style you want.

Instant custom combination chart, and you did it yourself!

- Jon
 
T

Tushar Mehta

In addition to Jon's suggestion, check Tools | Data Analysis... |
Histogram

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
J

Jon Peltier

I particularly like the pie chart on page 3, "Proportion of Lunatics in
Massachusetts by County, 1854"

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top