Don't Want Zeros Plotted

[Phil Hageman]

I am plotting monthly values in a chart. While values for
January through June plot as expected, the chart is
plotting zeros for the remainder of the year. July
through December source cells are blank.

How do I make the chart plot only January through June,
and not plot zeros for the blank months July through
December?

Thanks, Phil

 

[Jerry W. Lewis]

If the cells were truly blank, they would not be plotted. Presumably
they contain formulas like
=IF(condition,"",formula)
Character strings, including "" are plotted as zero. There is nothing
that a formula can return that would behave exactly as though the cell
were empty.

If you change "" to #N/A, then the chart will not plot the #N/A values,
but they may cause problems with other formulas. Alternately, you could
delete the formulas and only replace them when they are non blank. This
could be automated by a macro.

Jerry

 

[Phil Hageman]

Jerry, Thanks for your reply. I think the macro thing may
be the solution. All chart series point to a table where
cells hold a link formula, which in turn look at the
source cell. I need to have the table stay in tact -
holding the formulas. What would macro coding be? Would
it be based on an entry in the source cell?

Phil