representing a 0 in a bar chart

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.

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.

rightmouse a gridline and select Format Gridlines, Scale, minimun = -1, crosses at -1
Adjust the -1 to suit.

Alternately, just set the 'Crosses at' to suit.
---

thanks for the reply, is there any other way of doing this or is that way the standard. Looks a bit strange starting it off as a -1, havent seen many other charts that look that way. Thank you very much.

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?
---