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
 

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

Similar Threads

How do I create a frequency polygon in Excel? 1
Displaying frequency polygons in Excel (Statistics) 3
Polygon Class 4
How do I create a Cumulative Frequency Histogram on Excel? 1
side-by-side relative frequency bar graph 1
Polygon and line collision detection 7
Need algorithm to detect region/polygon 6
pareto chart in Excel 2007? 1

Back
Top