Graphing Woze?

[Guest]

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

 

[Rob van Gelder]

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

 

[Guest]

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.

 

[Myrna Larson]

Another option might be to use dynamic names for the series areas, with those
names referring to something like

=OFFSET($C$2,0,0,COUNTIF($C$2:$C$13,">0",1)

where you have some monthly data in C2:C13 that will never be <= 0

 

[Rob van Gelder]

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