Scatterplot treats letters as 0 numbers, how to prevent that?

Calathia

New Member
Joined
Oct 27, 2017
Messages
8
I have same data points from equation =IFERROR(K3+Q3;""). When I plot these numbers and "" blanks into scatter plot, "" blanks are treated as 0 numbers. Is there any way to prevent that?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,095,479
Messages
5,444,723
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top