How do I create a Cumulative Frequency Histogram on Excel?

B

Bassman1514

I want to create a Cumulative Frequency Histogram on my Microsoft Excel 2007.
I can create a line graph or a column graph, but not both in the same graph.
There probably is a way to do this, but im not very familiar with graphs on
Excel 2007 yet, so any help is appreciated.
 
B

Bernard Liengme

Let's say you have (starting in A1)
Range Freq
rangeA 12
rangeB 20
rangeC 30
.....

In C1 enter "Cumm", in C2 enter =B1; in C3 enter =C2+B3 and copy down the
column
Make a chart of this data (A1:C20)
Maybe format the cumulative data series to make a Line if the individual
data is as columns

best wishes
 

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