SCW,

Try one of these "fixes":

(1) Enter the formula "=NA()" for those cells that have zero values. The
X-Axes labels will be displayed but the series will not.
(2) Click on your chart and in the standard toolbar go to Tools - Options
- Chart - "Plot empty cells as" option.

----
Regards,
John Mansfield
http://www.pdbook.com

"SCW" wrote:

I am building a set of templates to automate building charts and reporting
information. Is there a way to keep Excel charts from displaying a zero
value for future information, i.e. actual usage in March 2005, while
retaining the appropriate cell reference?