Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Show Changes in Month without resuming x axis datetime data

Hi I have this dispersion graph every dot represents a datetimezone datatype on x axis. I want to just show changes in months in x axis. For example this would be nice to accomplish as x-axis data in order to being able to visualize changing in month but without lossing the visibility of the data (without resuming). I just put the data below the graph I want to hide

 

This is how I want to show the info. I know I can hide x-axis with the toggle option but I dont know how to add the dates as shownm below

        01/05/2021                                      01/06/2021                                                                                        01/07/2021

 

 

Any tip would be really appreciated

 

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee

    Do you have your x-axis set as categorical or continuous?  If categorical, try switching that first.

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi mahoneypat. I dont know why but my x-axis do not show me that option.

       

      X- axis ( Color, Font size, Font family, Width of minimum category, Maximum size, Internal space, Title )

      Any clarification would be really appreciated. Perhaps I need to do something with the data before, in order enable that feature but I don´t know what exactly is needed.

       

      Thank for your help,

       

      Julio

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee

    You are looking in the right place if you are using a line chart.  What type of chart are you using?  Also, is the column used on the x-axis set to Date data type?

     

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      mahoneypat actually is a Dispersion Graph and my x-axis is DateTimeZone datatype