Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2014, 11:52 PM
tays01s tays01s is offline Chart: Cumulative line Mac OS X Chart: Cumulative line Office for Mac 2011
Novice
Chart: Cumulative line
 
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
  #2  
Old 02-18-2014, 05:03 AM
macropod's Avatar
macropod macropod is offline Chart: Cumulative line Windows 7 32bit Chart: Cumulative line Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart: Cumulative line 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: Cumulative line chart axis text line breaks Saskabush PowerPoint 1 09-12-2012 10:48 AM
Chart: Cumulative line Bestfit Line Chart DataLabels chubby92 Excel 1 01-26-2012 09:46 PM
Chart: Cumulative line Adding a goal line to a chart uhlersa Excel 1 01-16-2012 08:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft