Quote Originally Posted by loogiestloo
Hi everyone,

I have a series of bar charts but some of data collected resulted in 0 responses thus no bar. Is there any way to put a 0 where the bar would have been whilst not having the figures above every bar in the chart. In statistics is there some kind of special way to show the responses are 0 on a bar chart. I presumed having no bar there at all spoke for itself but others have told me that isnt the case as it could look as if an error had been made in the formulas etc.

Any advice would be greatly appreciated
Thank you.
Ignoring my 1:07am reply, one simple possibility is to set the Category axis to contain this, as =If(A1=0,"CatName=0""CatName") tailored to your needs.
Another possibility is to set the fill with a picture that contains some text that is normally overwritten by the bars, but you may need to set the Gap Width smaller (and the bars wider) to achieve this.

does either of these help?
---