# Formula Result that Graphs like an Empty Cell?

#### Cerestes

##### Board Regular
If I graph a range of numbers, I get a nice continous graph.
If I delete one number in the middle of the range, my graph looks the same but with one 'missing' point (and the lines that connect it).

This is exactly what I want to do, but I'm not graphing hard numbers.
Everything in the range is the result of VLOOKUPs, and IF statements.

What I need is 'something' that the formulas can return that graphs exactly the same as an 'empty' cell.

Any ideas?

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hi
What do you want to be the result of the formula? is it 0 or "" ?
I suggest you to set the formula so that on this condition it will give =NA() this will ignore that point in the graph.
Eli

Ah! I think this is a partial solution.

Having the formula's return NA() makes my graphs correct.

The only issue I see know are two small sections where the results are averaged or summed.

Is there a simple formula to 'skip' cells that are "N/A"?
It needs to sum (or average) all cells in the range, but ignore N/A's.
Something like "=SUMIF(range,ISNA())"?

Replies
0
Views
531
Replies
3
Views
691
Replies
2
Views
406
Replies
3
Views
1K
Replies
4
Views
2K

1,203,239
Messages
6,054,314
Members
444,715
Latest member
GlitchHawk

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back