Prev: I'm looking to great a multi month fundraiser temperature graph.
Next: Why do my pie charts have labels which say "add text"?
From: Jon Peltier on 18 Mar 2010 08:28 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? |