View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ted
 
Posts: n/a
Default How do I do a cumulative frequency graph?

I have a large amount of data (60k lines) and want to display a cumulative
frequency of the data. Example... chart starts @ 0,0 and end at $1.00 (x) and
100% (y). It will visually show at any given x value (between 0 and 1.00) the
cumulative % of the time that value (and below) comes up. (.50 and below is
40% of the data).

I have played with histograms, but that just shows the frequency of 1 x
value. I need this to be cumulative for that x value and all values lower
than it.

Any ideas?