Forum Discussion

Eric_Hoo's avatar
Eric_Hoo
Copper Contributor
May 27, 2021
Solved

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

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 hi...
excel
office 365
  • HansVogelaar's avatar
    HansVogelaar
    May 27, 2021

    Eric_Hoo 

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

     

  • Eric_Hoo's avatar
    Eric_Hoo
    Copper Contributor
    May 27, 2021

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

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 27, 2021

      Eric_Hoo 

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

       

      • Eric_Hoo's avatar
        Eric_Hoo
        Copper Contributor
        May 27, 2021
        thanks a lot. it there any other method to keep the space with -0.25 but the x-axis shows as I want?

Resources