If you have anything in the cell besides NA() or #N/A, you will get an
apparent zero value in the chart. You can hide the #N/A error with
conditional formatting:
http://contextures.com/xlCondFormat03.html#Errors

I don't like hiding anything important, I prefer keeping the range as is.
What I often do, though, is keep the chart data range as is for myself, but
insert another sheet with the same data, cleaned up and formatted for a nice
printed report, or an on-screen table. It just takes a few links, and you
didn't have to mess up one data range to try to make it work for two
purposes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Lin" wrote in message
...
Jon,

Just jumping in here with a follow up question. Your suggestion worked
perfectly and the chart no longer shows the zero value. The individual
cells
however display the characters #N/A. Is there any way to either suppress
that, or get it to display something like "upcoming" or "future"?

Thanks in advance.

"Jon Peltier" wrote:

Change "" in your formulas to NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DOUG ECKERT" wrote in message
...
I have a linked chart built through the end of the fiscal year based on
a
spreadsheet supplied by another office. WITHOUT hiding spreadsheet
columns
or deleting cell content or changing chart coordinates, I would like to
instruct the chart not to plot future month's cells with zero values.
Is
this possible?