Nov 12 2018 04:01 AM
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!!
Nov 12 2018 09:27 AM
Hi Richard,
Better if you attach some sample file. However, did you try format duration as elapsed time [hh]:mm ?
Nov 13 2018 01:43 AM
Hi Sergei - thanks for your idea. Sample data attached and see the random y axis values?
Any other ideas?
Thanks,
Richard
Nov 13 2018 02:14 AM
Hi Richard,
If you mean y-axis units you may define major one manually, let say as 0.0833333 which is equal to 2 hours
Nov 13 2018 05:23 AM
That's great Sergei - thank you very much!
Richard
May 29 2019 09:40 AM
Thanks Sergei, I've been struggling with this one, and your answer really helped!
Regards
Ken