Don't chart X-axis without values.

[Hank Werner]

On a line chart I am plotting two individual columns and
then SUM(ming) these two for a total. Future dates of the
individual columns have no data BUT the formula for
SUM(ming) the two results in zero (0) which is plotted on
my chart. I've tried a number of approches to the
formula, blank (""), and Null (which results in a string
and causes an error.

How can I leave my formula in the future dates and not
effect my chart. Obviously, with moving from 300k to zero
in one week is scary.

Thanks,
Hank

 

[Jon Peltier]

Hank -

Excel can't return a NULL or BLANK from a function (not that we haven't
suggested it), but if you use NA(), you at least get an #N/A error,
which charts mostly ignore.

You could also make a dynamic chart, based on a dynamic range. This
could include only non-blank cells, or exclude non-numeric cells. There
are examples and links here:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

- Jon