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?