Microsoft KB Archive/147877

{|
 * width="100%"|

OFF: How to Set Time Units in Microsoft Graph 5.0

 * }

Q147877

-

The information in this article applies to:


 * Microsoft Graph for Windows, version 5.0
 * Microsoft PowerPoint for Windows, version 4.0
 * Microsoft PowerPoint for Macintosh, version 4.0
 * Microsoft PowerPoint for Windows, version 7.0
 * Microsoft Office for Windows, versions 4.2, 4.3
 * Microsoft Office for the Macintosh, versions 4.2, 4.2.1
 * Microsoft Office for Windows, 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 =  * .000695 (where  is the maximum number of minutes)

Major Unit = .003475 (5 minutes * .00695) To format the axis to one-hour increments:

Minimum value = 0

Maximum value =  * .0417 (where  is the maximum number of hours)

Major Unit = .0417 (1 hour * .0417) Additional query words: 5.00 msgraph times days incorrect setting values changing formatting powerpoint powerpnt word excel chart

Keywords : kbusage

Issue type : kbhowto

Technology :