LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw cumulative frequency curve in Excel Alvin Charts and Charting in Excel 2 April 23rd 23 09:03 AM
Line graph for cumulative number over time Jane Charts and Charting in Excel 0 April 9th 06 07:19 AM
How do you create a cumulative line graph? Ray Excel Discussion (Misc queries) 4 December 4th 05 11:11 PM
Cumulative Frequency Chris Grant Charts and Charting in Excel 2 February 3rd 05 05:49 AM
How to make cumulative totals appear on a graph Arlen Excel Discussion (Misc queries) 1 January 17th 05 08:59 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"