Looking at other posts, within a formula returning #N/A instead of zero works
well in omitting that point plotted. I have additional formulas else ware
that require a zero displayed where #N/A fouls things up. Is there another
way to suppress plotting zeros in a series?

Appreciatively,
Arturo

You're having the same problem many people have when they think they can only have
the data in one place. In your situation, I'd likely use three ranges. The first
range contains the original data. The second range contains the data to be plotted,
linked to the original, with NA() in the formulas where necessary. The third range
contains data linked to the original, processed for further numerical analysis or
for tabular display, with zero or other appropriate values returned from the
formula. Each data set is then optimized for its purpose. If desired you can hide
the original data on another sheet.

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

Arturo wrote:

Looking at other posts, within a formula returning #N/A instead of zero works
well in omitting that point plotted. I have additional formulas else ware
that require a zero displayed where #N/A fouls things up. Is there another
way to suppress plotting zeros in a series?

Appreciatively,
Arturo

I can be such a block-head some times.
It all seems so clear now...
Thank you Jon.
Arturo

"Jon Peltier" wrote:

You're having the same problem many people have when they think they can only have
the data in one place. In your situation, I'd likely use three ranges. The first
range contains the original data. The second range contains the data to be plotted,
linked to the original, with NA() in the formulas where necessary. The third range
contains data linked to the original, processed for further numerical analysis or
for tabular display, with zero or other appropriate values returned from the
formula. Each data set is then optimized for its purpose. If desired you can hide
the original data on another sheet.

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

Arturo wrote:

Looking at other posts, within a formula returning #N/A instead of zero works
well in omitting that point plotted. I have additional formulas else ware
that require a zero displayed where #N/A fouls things up. Is there another
way to suppress plotting zeros in a series?

Appreciatively,
Arturo

No, it's not being a blockhead. It's just forgetting that the computer is supposed
to serve YOU.

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

Arturo wrote:
I can be such a block-head some times.
It all seems so clear now...
Thank you Jon.
Arturo

"Jon Peltier" wrote:


You're having the same problem many people have when they think they can only have
the data in one place. In your situation, I'd likely use three ranges. The first
range contains the original data. The second range contains the data to be plotted,
linked to the original, with NA() in the formulas where necessary. The third range
contains data linked to the original, processed for further numerical analysis or
for tabular display, with zero or other appropriate values returned from the
formula. Each data set is then optimized for its purpose. If desired you can hide
the original data on another sheet.

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

Arturo wrote:


Looking at other posts, within a formula returning #N/A instead of zero works
well in omitting that point plotted. I have additional formulas else ware
that require a zero displayed where #N/A fouls things up. Is there another
way to suppress plotting zeros in a series?

Appreciatively,
Arturo