Line Chart Looks Bad

[rockyw]

Is there any way to make a line chart that will not show an enpty cell as ZERO? BUT! there is a formula in that cellm is that why it shows a 0? The cells that feed the chart are all filled with formulas. Thanks

 

[shg]

Is the problem with blank cells (cells that contain nothing, not even a formula that returns "") or cells with formulas that return 0?

 

[rockyw]

The cells all have a formuls in them. Like this ='2ND 4 WK'!C14
Is there a way to keep excel from ploting that as a zero? Thanks

 

[shg]

If the result is always a number (0 or otherwise), then

=if('2ND 4 WK'!C14, '2ND 4 WK'!C14, #N/A)

 

[rockyw]

OK my formula is this now =IF('3RD 4 WK'!C13,'3RD 4 WK'!C13,"#N/A")

And I still have the chart ploting 0s What else can I do

 

[shg]

What value is the formula returning?

What's in C14?