Don't Want Zeros Plotted

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

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
 
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
 
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
 
Back
Top