-
1. Re: Y-Axis in Hours - Custom Sorting
Zhouyi ZhangJul 3, 2018 5:17 AM (in response to Gian Pedrun)
Hi, Gian
You probably can use format to format your calculation result as hh:mm:ss, but it will be good if you can share a sample workbook.
ZZ
-
2. Re: Y-Axis in Hours - Custom Sorting
nikher verma Jul 3, 2018 5:26 AM (in response to Gian Pedrun)Hi Gian Pedrun ,
It would be better if you had been shared twbx file as it can be solved in many different ways .
I am not sure but you can solve it using dual axis chart and remove the number axis and keep only time axis .So you are just hiding the number axis and showing the time axis .
In case you stuck somewhere please attach your work .
-Nikher Verma
-
3. Re: Y-Axis in Hours - Custom Sorting
Gian Pedrun Jul 4, 2018 6:18 AM (in response to nikher verma)Hi Nikher
I have added the twbx file.
I have tried things with dual axis but was not able to resolve it ;-(
-
4. Re: Y-Axis in Hours - Custom Sorting
Zhouyi ZhangJul 4, 2018 6:25 AM (in response to Gian Pedrun)
Hi, Gian
Please find my solution attached.
Below is the screenshot of steps and result
Hope this helps
ZZ
-
test_file_v10.2.twbx 52.1 KB
-
-
5. Re: Y-Axis in Hours - Custom Sorting
Gian Pedrun Jul 5, 2018 1:59 AM (in response to Zhouyi Zhang)Hey Zhouyi
Thank you very much for quick answer. The solution is so simple ;-)
Regards
-
6. Re: Y-Axis in Hours - Custom Sorting
Zhouyi ZhangJul 5, 2018 4:36 AM (in response to Gian Pedrun)
No worries, glad it helped
ZZ