Dynamic Chart with Zero values

**kasimagj** · 05-28-2008, 03:38 PM

I am trying to make a dynamic chart so that future zero values (months with no data yet) do not show up on the chart.

With my spreadsheet, I have the values for the chart being referenced from other cells. Having several months that have zero values (which cannot be deleted), how can I have a dynamic chart to not display the zero values?

The dynamic charts work (from my understanding) if the zero values are actually BLANK values.

Using =NA# causes the same issue and has the extra months plotted which I don't want. Is there a way to make a cell that is equal to a zero value in another cell be blank/empty?

I've been working on this for hours and cannot find a solution.

I followed the steps from this thread: http://www.excelforum.com/showthread.php?t=470385

**ChemistB** · 05-28-2008, 03:54 PM

You can use the COUNTIF function in your defined name instead of the typical COUNTA. See attached. For the values, I used

Please Login or Register  to view this content.

and for the months

Please Login or Register  to view this content.

This will not work if you have 0 values for any past months.

ChemistB

**kasimagj** · 05-28-2008, 04:05 PM

You're my savior!! Thank you so much!

**arindamsenaxa** · 09-14-2015, 11:33 PM

Hi ChemistB

This really help me a lot in single sheet but when I try it in multipal sheet its giving some error .
I have tried all possible solution from my end now looking for your kind help in my attached sheet.
in both the sheet I have applied your formula for CT and OCT graph but whenever I put some data it throes some error.
also the Horizontal (Category) Axis Labels is not reflecting

please lookinto this mater ,it will be a great help.
I have to add total 8 same sheet bot now I have attached only 2 sheet .once it resolved i can add the rest sheet.

looking for your quick support.

Regards

Arindam

**protonLeah** · 09-15-2015, 12:56 AM

arindamsenaxa,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.