Thread: [Solved] Chart: Cumulative line
View Single Post
 
Old 02-10-2014, 11:52 PM
tays01s tays01s is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Jul 2011
Posts: 15
tays01s is on a distinguished road
Default 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.
Reply With Quote