View Single Post
  #1   Report Post  
TonyB
 
Posts: n/a
Default Charting cumulative values in histogram ?

I have a set of numbers 1-12 along with a corresponding % that number occurs
in some data I'm analyzing.
What I want to plot is a histogram with number bin 1 - 12 along the x axis,
and on the yaxis a cumulative value of the total % 's upto that number.
So for simple case with 4 numbers
1, 20%
2, 40%
3, 30%
4, 10%

so the cumulative values I would like to histogram would be
1, 20 %
2, 60%
3, 90%
4,100%
I can't seem to get this to work via the histogram charting tool in the
tools/data analysis menu ?
Can anyone give me any pointers as to how to achieve this ?
Regards
Tony