Hi
I'm creating a Gantt Chart in Excel that shows time elapsed between start times and end times. I want to have my y-axis to have units of 30 seconds, so I've got the major axis units set to 0.0003472222222222 (equal to 1/24/120).
This works fine if my graph doesn't span more than two hours, my labels work perfectly and display as 14:00:00, 14:00:30, 14:01:00, ...; however, when the graph spans more than a few hours, I end up with intervals of just over thirty seconds, e.g. 15:00:00, 15:00:30, 15:01:00, 15:01:30, 15:02:00, 15:02:31, ....
Is there any way to work around this? It seems odd since it's fine until I try and show more than four hours on the graph. I've tried adding more significant figures to my major axis units, but to no avail.
Thanks!
I'm creating a Gantt Chart in Excel that shows time elapsed between start times and end times. I want to have my y-axis to have units of 30 seconds, so I've got the major axis units set to 0.0003472222222222 (equal to 1/24/120).
This works fine if my graph doesn't span more than two hours, my labels work perfectly and display as 14:00:00, 14:00:30, 14:01:00, ...; however, when the graph spans more than a few hours, I end up with intervals of just over thirty seconds, e.g. 15:00:00, 15:00:30, 15:01:00, 15:01:30, 15:02:00, 15:02:31, ....
Is there any way to work around this? It seems odd since it's fine until I try and show more than four hours on the graph. I've tried adding more significant figures to my major axis units, but to no avail.
Thanks!