Q147877 - OFF: How to Set Time Units in Microsoft Graph 5.0

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 = <m> * .000695 (where <m> 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 = <h> * .0417 (where <h> 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 :