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

%3CLINGO-SUB%20id%3D%22lingo-sub-1481320%22%20slang%3D%22en-US%22%3Econvert%20from%20h%3Amin%3Asec%20to%20only%20minutes%20for%20graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481320%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20colleagues%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20had%20some%20struggles%20about%20converting%20my%20x-axis%2C%20which%20is%20given%20in%20h%3Amin%3Asec%20(or%20only%20seconds)%2C%20so%20it%20is%20expressed%20like%2000%3A50%3A20.%20However%2C%20I%20would%20like%20to%20change%20it%20to%20only%20show%20minutes.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20do%20it%20manually%26nbsp%3B%20by%20expressing%20my%20values%20in%200.01%2C%200.02....%200.59%20then%201.%20and%20chose%20to%20only%20show%20every%2060th%20value.%20However%2C%20this%20is%20really%20time%20consuming%20as%20I%20have%20a%20lot%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20data%20that%20is%20given%20in%20seconds%3A%20how%20can%20I%20express%20the%20x-axis%20in%20minutes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20example%20of%20each%20convertion.%3C%2FP%3E%3CP%3Ethanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481320%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481703%22%20slang%3D%22en-US%22%3ERe%3A%20convert%20from%20h%3Amin%3Asec%20to%20only%20minutes%20for%20graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481703%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681935%22%20target%3D%22_blank%22%3E%40Hafnia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20linear%20chart%20the%20minimum%20unit%20is%20date.%20What%20is%20shown%20in%20x-asis%20that%20is%20time%20taken%20as%20text%2C%20you%20can't%20convert%20it%20here.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20works%20is%20scatter%20chart.%20For%20it%20select%20XY%20series%20where%20X%20is%20time%2C%20as%20major%20unit%20for%20X-axis%20let%20take%2015%20min%2C%20that%20is%20equal%20to%2015%2F60%2F24%20and%20%3D0.0104166666666667.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20278px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200126i86DDBB88EB5A4C72%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWe%20may%20apply%20to%20the%20axis%20values%20elapsed%20time%20format%20in%20minutes%2C%20i.e.%20%5Bmm%5D%20unlinking%20it%20from%20data%20source%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200127iF6299DBACE69AB77%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EResult%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20434px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200128i5C9E542EC37E9D18%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20check%20in%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

1 Reply
Highlighted

@Hafnia 

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.

image.png

We may apply to the axis values elapsed time format in minutes, i.e. [mm] unlinking it from data source

image.png

Result is

image.png

Please check in attached file.