How do I create a Cumulative Frequency Histogram on Excel?

  • Thread starter Thread starter Bassman1514
  • Start date Start date
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.
 
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
 
Back
Top