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 and adding values #N/A with same result).

 

I have several charts with same option :

(Note I also tried checking "Show #N/A as an empty cell" with same result)

 

For one of my charts it works a expected :

 

But not for other ones like :

Is it linked to my values or to the type of chart ?

I have attached a minimal sample.

Thank you for your kind help.

 

 

 

3 Replies

    • takemi's avatar
      takemi
      Copper Contributor

      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

        takemi 

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