#1
|
|||
|
|||
Chart: Cumulative line
I want to plot a simple line of Y-axis cumulative registrations against X-axis cumulative time. Because it is easier to count the time it takes to get 50 registrations per web-page, as registration takes place at a faster rate, the time interval gets shorter and the line on the chart should get steeper. However, Excel's automated plot equally spaces each data point on the X-axis, giving a straight line as each data-point (webpage) adds 50 registrations. How do I get the X-axis to be proportionate instead of equally spaced labels that are really different time intervals. |
#2
|
||||
|
||||
Perhaps you're using the wrong units; instead of registration counts you might consider a time-based unit.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formulas for cumulative value and cumulative %? | Brotein | Excel | 1 | 10-29-2013 05:35 AM |
X/Y scatter chart with straight best fit line? | fmaduri | PowerPoint | 0 | 10-01-2013 09:53 AM |
chart axis text line breaks | Saskabush | PowerPoint | 1 | 09-12-2012 10:48 AM |
Bestfit Line Chart DataLabels | chubby92 | Excel | 1 | 01-26-2012 09:46 PM |
Adding a goal line to a chart | uhlersa | Excel | 1 | 01-16-2012 08:18 PM |