zero values in charts-don't want to show as zero, but as blank

G

Guest

I am trying to create a chart from data that is in the form of a formula,
some of those cells have a formula that returns a blank cell, "". I want my
line chart to stop if the cell is blank, instead it is showing as a zero
value.
Any ideas on how to do this.
 
G

Guest

I am not 100% positive this is your situation, but I believe I ran into the
same problem a few weeks back. On your spreadsheet got to Tools/Options,
then on the View tab uncheck Zero values.
 
G

Guest

Unfortunately, that is not the problem. When I create my chart it still is
showing those value as 0.
 
R

RagDyer

Revise your formulas to return the #N/A error.
That error message is invisible to charts.

=IF(A1+B1=0,#N/A,A1+B1)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top