Hiding part of graph lines

[Jeff Bremer]

We have graphs that display monthly data trends set-up to read formulas. Formulas for future periods equal zero. Is there a way to hide the line of the graph for each month with a value of zero?

Thanks, Jeff

 

[Datsmart]

Jeff, Welcome to the board.

In chart source range, set zero's to show NA() instead of "" or 0.
You will see N/A# in your table but they will not show or plot in the chart or chart table.
Use a formula similar to this…
=IF(C35=0,NA(),C35)

The link below explains it better than I can.
http://www.tushar-mehta.com/excel/software/na_discontinuity/index.html