Graphing Woze?
 

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

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

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

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

On Thu, 27 Jan 2005 09:50:18 +1300, "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.

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