Just so you know, unchecking "Zero Values" has no effect on zeros with
charting.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"cincode5" wrote in message
...
I dont know for a fact that this will work, but try going to:
TOOLS, OPTIONS,
then uncheck Zero Values in the View Tab.

Excel will not display anything that equals Zero. It may also apply to
Charts.

Good luck.



"Rob van Gelder" wrote:

Excel Charts ignore cells #N/A,
Try putting =NA() into those blank cells.
You should be able to build a solution from there.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Arlen" wrote in message
...
Hello. I have Graphing Woes. Basically, I don't want to graph zeros.
Let
us say that the user is inputing two kinds of production dollars every
day.
Production 1 and Production 2 graph fine individually, i.e., the graph
stops
where the numbers stop, because they are blank cells until the user
inputs
numbers. But the graph of TOTAL (Type 1&Type 2) graphs all the zeros
until
the end of the column. I realize this is because TOTAL has zeros
stored
in
it until the formula receives other number, but I've tried putting in
""
instead of zeros and I've tried Chart Options -Don't Plot Zeros.
Neither
works. How do I keep the total chart looking like the individual
charts?

Thanks, Arlen