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

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

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