Charting activity time duration in excel

Question

Hi - I'm trying to chart activity duration in excel that's been calculated from start and end times on a given day.

The duration column is formatted as hh:mm from the custom field format. However, when I turn it into an area chart, the y axis which is the duration (x axis is activity) is shown as the actual time and not the duration, despite being formatted as hh:mm. I've even tried formatting the y axis as both time and custom and it still shows the time of day rather than duration. Any help much appreciated!!

sergeibaklan · Answer

Hi Richard,
&nbsp;
Better if you attach some sample file. However, did you try format duration as elapsed time [hh]:mm ?

richard kimber · Answer

Hi Sergei - thanks for your idea. Sample data attached and see the random y axis values?Any other ideas?&nbsp;Thanks,&nbsp;Richard

sergeibaklan · Answer

Hi Richard,
&nbsp;
If you mean y-axis units you may define major one manually, let say as 0.0833333 which is equal to 2 hours

&nbsp;

richard kimber · Answer

That's great Sergei - thank you very much!&nbsp;Richard

kencollins · Answer

Thanks Sergei, I've been struggling with this one, and your answer really helped!&nbsp;RegardsKen

Forum Discussion

Charting activity time duration in excel

5 Replies

Resources