removal of zero in column chart

[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.

 

[Guest]

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

 

[Guest]

An alternative to bj's suggestion would be to use array formulas with a
secondary chart reference to eliminate the zero values. This site shows how
and provides a workbook that can be downloaded.

http://www.pdbook.com/index.php/excel/omitting_x_axis_labels_tied_to_zero_values/

 

[Caroltchr]

thanks. i downloaded and incorporated the worksheet. worked great.