removal of zero in column chart

  • Thread starter Thread starter Caroltchr
  • Start date Start date
C

Caroltchr

I have a worksheet that charts weekly values. I put these values into
a chart, which is regularly updated as I change the weekly values. I
don't want any zerio values to be charted. Is there any way for me to
have the chart only display the >0 values and display NO COLUMN if the
value was zero? thanks.
 
Where does the X axis cross the Y axis?
If what you mean is that you dont want the catagories with 0 to be plotted,
the simplest way to do it depends on whether you have the data in columns or
rows.
Since the charts by default only plot from visible cells, You can hide the
columns or rows with zeros in them and the chart will not have a spot for
that area.
You can use auto filter to hide zeros for data in columns. you have to
physically hide and unhide zeros ifor data n rows
 
Back
Top