Forum Discussion

takemi's avatar
takemi
Copper Contributor
Jul 31, 2020
Solved

force gap with Hidden and Empty Cells

Excel 365 MSO Hello, I have some series of values covering several years and I would need to make a visual separation between each year. I thus added a blank line : (Note I tried blank line...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 31, 2020

takemi 

You may format X-axis as the text (not dates) or change format of linear series on Scatter one setting gaps for empty cells.

  • takemi's avatar
    takemi
    Copper Contributor
    Aug 01, 2020

    Thanks a lot SergeiBaklan 

    Changing x-axis format from date to text did the trick for all charts type I could test.

    Thanks again.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 02, 2020

      takemi 

      You are welcome. Please note, with text gaps will be in X-axis as well, it won't be continuous dates axis.