Forum Discussion
convert from h:min:sec to only minutes for graphs
Dear colleagues, I have had some struggles about converting my x-axis, which is given in h:min:sec (or only seconds), so it is expressed like 00:50:20. However, I would like to change it to only ...
For the linear chart the minimum unit is date. What is shown in x-asis that is time taken as text, you can't convert it here.
What works is scatter chart. For it select XY series where X is time, as major unit for X-axis let take 15 min, that is equal to 15/60/24 and =0.0104166666666667.
We may apply to the axis values elapsed time format in minutes, i.e. [mm] unlinking it from data source
Result is
Please check in attached file.