How to remove space or # N/A on a bar cart in excel.

[kevin67]

Hello

I am new on Chandoo. I am looking assistance on a bar chart . I want that the value is empty or #n/a on the bar chart it does not leave a space between the bars.

I have enclosed my file on sheet two. I would be grateful if someone can assist me on this issue.

Thanking for your cooperation

 

[vletm]

kevin67
Could You use Your chart as below?
Then You could see Your gaps better and adjust those as below.

 

[kevin67]

kevin67
Could You use Your chart as below?
Then You could see Your gaps better and adjust those as below.
View attachment 69939

Thanks Vletm for your solution. I am looking one where the audience can read the chart easily but if i do not get a better solution i will use this one.