Jun 22 2020 09:02 AM
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 show minutes.
I can do it manually by expressing my values in 0.01, 0.02.... 0.59 then 1. and chose to only show every 60th value. However, this is really time consuming as I have a lot of data.
For data that is given in seconds: how can I express the x-axis in minutes?
Any ideas?
I have attached an example of each convertion.
thanks.
Jun 22 2020 11:15 AM
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.