Forum Discussion

Deleted's avatar
Deleted
Jul 16, 2019

Chart won't plot a zero

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

excel

2 Replies

  • Theo_Bear's avatar
    Theo_Bear
    Copper Contributor
    Jul 17, 2019

    Deleted 

     

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

  • Theo_Bear's avatar
    Theo_Bear
    Copper Contributor
    Jul 16, 2019

    Deleted 

     

    Hi 

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

Resources