frequency polygon help!!

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
I particularly like the pie chart on page 3, "Proportion of Lunatics in
Massachusetts by County, 1854"

- Jon
 
Back
Top