Make chart ignore values that calculate to nothing or empty

[JoeMajestee]

I'm not sure about the vocabulary, so please let me know the right words.
I have a chart. I want it to display the entire fiscal year, APR to MAR. In the middle of the year, I want it to use the data so far, but keep the rest of the chart blank. If it's September and I haven't given it the rest of the year, I want the line to stop at August.

I dump a year's worth of data into the sheet and have an if function that says if data is not there, then cell = "". If I make a chart out of the data in the attached sheet, the line goes to zero for October and beyond. I don't want the zeros, I just want the line to stop. If I remove the formulae from C8:D13, I get what I want.

M - Incident Ticket Open Time - Monthly - FY24 - Copy.xlsm
	A	B	C	D	E	F	G
1		Objective	Avg Ticket Open Time	# of tickets		Data
2	APR	1	0.76	50		0.76	50
3	MAY	1	1.613636364	44		1.613636	44
4	JUN	1	1.204819277	83		1.204819	83
5	JUL	1	3.356164384	73		3.356164	73
6	AUG	1	1.485714286	70		1.485714	70
7	SEP	1	2.055555556	18		2.055556	18
8	OCT	1
9	NOV	1
10	DEC	1
11	JAN	1
12	FEB	1
13	MAR	1
14
Sheet2

Cell Formulas
Range	Formula
C2:D13	C2	=IF(F2="","",F2)

 

[awoohaw]

try changing your formula to:

=IF(F2="",NA(),F2)

Mr excel questions 60.xlsm
	A	B	C	D	E	F	G
1		Objective	Avg Ticket Open Time	# of tickets		Data
2	APR	1	0.760	50		0.760	50
3	MAY	1	1.614	44		1.614	44
4	JUN	1	1.205	83		1.205	83
5	JUL	1	3.356	73		3.356	73
6	AUG	1	1.486	70		1.486	70
7	SEP	1	2.056	18		2.056	18
8	OCT	1	#N/A
9	NOV	1	#N/A
10	DEC	1	#N/A
11	JAN	1	#N/A
12	FEB	1	#N/A
13	MAR	1	#N/A
JoeMajestee

Cell Formulas
Range	Formula
C2:C13	C2	=IF(F2="",NA(),F2)
D2:D13	D2	=IF(G2="","",G2)