Automatically skip dates when data is zero
 

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

Automatically skip dates when data is zero
 

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/...de_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/...de_zero_values

Hopefully these examples can help.

--
John Mansfield
http://cellmatrix.net





"Bob" wrote:

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

Automatically skip dates when data is zero
 

John,
Thanks for the examples!
Bob


"John Mansfield" wrote:

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/...de_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/...de_zero_values

Hopefully these examples can help.

--
John Mansfield
http://cellmatrix.net





"Bob" wrote:

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