SOLVED

How to change the x-axis scale to indicate the point of 00:00:00

%3CLINGO-SUB%20id%3D%22lingo-sub-2390634%22%20slang%3D%22en-US%22%3EHow%20to%20change%20the%20x-axis%20scale%20to%20indicate%20the%20point%20of%2000%3A00%3A00%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390634%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20my%20current%20figure%20is%20shown%20in%20the%20below%20picture.%20Could%20you%20please%20tell%20me%20how%20to%20change%20the%20x-axis%20and%20make%20the%2000%3A00%3A00%20indicated%20in%20the%20x-axis.%20I%20also%20mark%20the%20x-axis%20I%20want%20(in%20red%20highlights).%20Thanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2390634%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2390703%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20x-axis%20scale%20to%20indicate%20the%20point%20of%2000%3A00%3A00%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390703%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064586%22%20target%3D%22_blank%22%3E%40Eric_Hoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESet%20the%20minimum%20to%200.0%20and%20the%20maximum%20to%203.0%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0452.png%22%20style%3D%22width%3A%20274px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284234iCF974FB6BD50885E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0452.png%22%20alt%3D%22S0452.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2390715%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20x-axis%20scale%20to%20indicate%20the%20point%20of%2000%3A00%3A00%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BHi%2C%20thanks%20a%20lot%20for%20your%20prompt%20reply.%20It%20is%20a%20good%20way%20to%20solve%20the%20problem.%20But%20I%20want%20to%20set%20some%20distance%20between%20the%20y-axis%20and%20the%20curves.%20thanks.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Eric_Hoo_0-1622109665143.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284235iA260001983F7420F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Eric_Hoo_0-1622109665143.png%22%20alt%3D%22Eric_Hoo_0-1622109665143.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2390807%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20x-axis%20scale%20to%20indicate%20the%20point%20of%2000%3A00%3A00%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390807%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064586%22%20target%3D%22_blank%22%3E%40Eric_Hoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESet%20the%20Minimum%20to%20-0.5%20and%20specify%20that%20the%20vertical%20axis%20crosses%20at%20-0.25%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0453.png%22%20style%3D%22width%3A%20267px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284240iC9C22DC564EDC18D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0453.png%22%20alt%3D%22S0453.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone, my current figure is shown in the below picture. Could you please tell me how to change the x-axis and make the 00:00:00 indicated in the x-axis. I also mark the x-axis I want (in red highlights). Thanks a lot.

6 Replies

@Eric_Hoo 

Set the minimum to 0.0 and the maximum to 3.0

 

S0452.png

@Hans Vogelaar Hi, thanks a lot for your prompt reply. It is a good way to solve the problem. But I want to set some distance between the y-axis and the curves. thanks. 

Eric_Hoo_0-1622109665143.png

 

best response confirmed by Eric_Hoo (New Contributor)
Solution

@Eric_Hoo 

Set the Minimum to -0.5 and specify that the vertical axis crosses at -0.25:

 

S0453.png

thanks a lot. it there any other method to keep the space with -0.25 but the x-axis shows as I want?

@Eric_Hoo 

It looks OK to me with the settings I mentioned:

 

Chart.png

Thanks a lot. It helps a lot. Cheers, mate.