Hello,
I'm currently making a Gantt Chart with an hourly scale. I have my start time, end, time, duration, and a duration converted into decimal equivalent for 24-hours ( multiplying by 1/24)
But when I try to change the x-axis on my chart, ie maximum minimum minor units major units, the numbers are in accounting format thus 12/20/2010 6:30 PM becomes 40,403.38.
How can i fix this scale so that if i set the maximum as 1, it'll be 12:00 AM and if it was .5 12:00 PM and so on. Basically how can I change this accounting format of the axis.
Bookmarks