This has nothing to do with VBA; these are purely worksheet formulas. In the
linked cells, you must have a formula like

=A1

or

=IF(ISBLANK(A1),"",A1)

Change these both to something like

=IF(ISBLANK(A1),NA(),A1)

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


"DOUG ECKERT" wrote in message
...
Jon: Is this in the VBA instructions? I looked there, but could not find
it.

DOUG

"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?