New Contributor

# 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 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.

# Re: convert from h:min:sec to only minutes for graphs

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