Excluding Null Value that appears as zero in a chart

[shepcs]

HI
I created a formula that says if the value is equal to or less than zero, use "". However, when you go to chart it recognizes it as a zero instead of just breaking the line (I manually did it in the pics). Any way to prevent excel from doing this just for the chart data (as opposed to the greater workbook)? Appreciate any help

Chart.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1														DA LMP	Gas		RAW
2													8/1	$93.71	$8.16		$8.16
3													8/2	$82.78	$7.88		$7.88
4													8/3	$69.15	$8.97		$8.97
5													8/4	$68.78	$8.45		$8.45
6													8/5	$66.24	$9.10		$9.10
7													8/6	$70.99	$9.10		$9.10
8													8/7	$88.76	$9.10		$9.10
9													8/8	$66.10	$7.35		$7.35
10													8/9	$54.70	$5.81		$5.81
11													8/10	$54.96	$4.99		$4.99
12													8/11	$53.55	$4.89		$4.89
13													8/12	$49.73	$4.80		$4.80
14													8/13	$56.27	$4.80		$4.80
15													8/14	$97.18	$5.86		$5.86
16													8/15	$189.19	$8.06		$8.06
17													8/16	$265.13	$8.11		$8.11
18													8/17	$97.88	$8.09		$8.09
19													8/18	$59.35	$6.19		$6.19
20													8/19	$51.65	$4.11		$4.11
21													8/20	$52.34	$3.51		$3.51
22													8/21	$52.83		<-Why does this register as a zero when the formula is ""	($500.00)
23													8/22	$46.15	$3.79		$3.79
24													8/23	$45.13	$3.85		$3.85
25													8/24	$44.10	$3.61		$3.61
26													8/25	$52.35	$4.50		$4.50
27													8/26	$48.55	$2.87		$2.87
28													8/27	$53.64	$4.63		$4.63
29													8/28	$119.10	$5.39		$5.39
30													8/29	$106.56	$11.15		$11.15
31													8/30	$86.59	$7.03		$7.03
32													8/31	$46.75	$3.73		$3.73
1

Cell Formulas
Range	Formula
Q2:Q21,Q23:Q32	Q2	=O2
O2:O32	O2	=IF(Q2<0,"",Q2)

 

[Jeffrey Mahoney]

Use =NA() instead. Charts see this as no data

 

[shepcs]

That totally worked. Thanks Jeff!

Use =NA() instead. Charts see this as no data

That totally worked. Thanks Jeff!