Automatically skip dates when data is zero

[Bob]

In a clustered column chart, is there a way to make Excel automatically
"skip" a date (or dates) on the X-axis when the value for the date(s) equals
zero?

Thanks in advance for any help.

Bob

 

[John Mansfield]

This example use a formula in a helper column to exclude any data with zero
values from the chart.

http://www.cellmatrix.net/index.php/site/analysis/bar_chart_exclude_zero_values

The next example is slightly more complex as it excludes the zero values
from a pie chart as well as sorts the data.

http://www.cellmatrix.net/index.php/site/analysis/pie_chart_exclude_zero_values

Hopefully these examples can help.

 

[Bob]

John,
Thanks for the examples!
Bob

This example use a formula in a helper column to exclude any data with zero
values from the chart.

http://www.cellmatrix.net/index.php/site/analysis/bar_chart_exclude_zero_values

The next example is slightly more complex as it excludes the zero values
from a pie chart as well as sorts the data.

http://www.cellmatrix.net/index.php/site/analysis/pie_chart_exclude_zero_values

Hopefully these examples can help.