OFF: How to Set Time Units in Microsoft Graph 5.0

ID: Q147877

The information in this article applies to:

• Microsoft Graph for Windows, version 5.0
• Microsoft Graph for Windows 95, version 5.0
• Microsoft Graph for Macintosh, version 5.0
• Microsoft PowerPoint for Windows, version 4.0
• Microsoft PowerPoint for Macintosh, version 4.0
• Microsoft PowerPoint for Windows 95, version 7.0
• Microsoft Office for Windows, versions 4.2 and 4.3
• Microsoft Office for Macintosh, versions 4.2 and 4.2.1
• Microsoft Office for Windows 95, version 7.0

SUMMARY

To customize time values on an axis in a Microsoft Graph 5.0, you must use decimal time, because Microsoft Graph bases all time values on whole day increments.

MORE INFORMATION

If the data in the data sheet has been formatted as time values such as H:MM, the axis labels will be formatted in a time format automatically. You can customize the scale so that hourly or specific minute increments appear.

Here are a couple of samples you can use to figure time values for formatting the axis on your graph:

   One Hour is .0417 (1/24 of a day)
   One Minute is .000695 ( 1/(24 hours * 60 minutes) )
   One Second is .0000116 ( 1/(24 hours * 60 minutes * 60 Seconds) )

Examples

To format the axis to five-minute increments:

   Minimum value = 0
   Maximum value = <m> * .000695 (where <m> is the maximum number of
                                  minutes)
   Major Unit = .003475 (5 minutes * .00695)

   Minimum value = 0
   Maximum value = <h> * .0417 (where <h> is the maximum number of hours)
   Major Unit = .0417 (1 hour * .0417)

Keywords          : kbusage
Version           : WINDOWS:5.0; MACINTOSH:5.0
Platform          : MACINTOSH WINDOWS
Hardware          : MAC x86
Issue type        : kbhowto

Last Reviewed: February 3, 1998