Chart won't plot a zero

Deleted
Not applicable

Hi,

I'm making a chart and for some reason it won't plot a value at zero, instead it plots it at 1 and the data that was meant to be plotted at 1 at 2 etc. Is there anyone who has an idea why this might be happening?

Thanks

2 Replies

@Deleted 

 

Hi 

Are/Is the zero(s) visible in the data-set (cell/s) from which the graph is based? 

@Deleted 

 

Hi, highlight the graph and press ctrl +1, Format axis, expand the Axis Options section and set the Minimum value to 0.