Thread: x-axis scaling
View Single Post
  #6  
Old March 18th, 2010, 12:28 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default x-axis scaling

Make an XY chart, which will show the times proportionally. A line chart
spaces them equally regardless of value.

In 2007 you'll have to convert times to fractions (24 hours = a whole
day, so 12 hours = 0.5 etc.) in order to enter them as scale parameters.
Previous versions were smart enough to accept times or dates in the dialogs.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/17/2010 3:21 PM, todd wrote:
I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?