Line graph to only show latest date (and no blank / empty cell values)

[surkdidat]

The below is created from a formula dragged from another sheet of COUNTIF statements.

However, I would like the graph to only go up to the last day with data in the cell, starting 1 Feb. (ie so no nil values displayed, and to todays date only, but expands automatically every day I add data in

 

[etaf]

to stop the data showing zero - you could add a new set of columns
with the value as #n/a instead of blank
and copy the values across
something like

=IF( cell with date <= today() , value in cell, #N/A)

 

[etaf]

fror example
here

Note the #N/A does not need "" around OR you can use NA() instead

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	date				date	value
2	2/1/23	1			2/1/23	1
3	2/2/23	2			2/2/23	2
4	2/3/23	3			2/3/23	3
5	2/4/23	4			2/4/23	4
6	2/5/23	5			2/5/23	5
7	2/6/23	6			2/6/23	6
8	2/7/23	7			2/7/23	7
9	2/8/23	8			2/8/23	8
10	2/9/23	9			2/9/23	9
11	2/10/23	10			2/10/23	10
12	2/11/23	11			2/11/23	11
13	2/12/23	12			2/12/23	12
14	2/13/23	13			2/13/23	13
15	2/14/23	14			2/14/23	14
16	2/15/23	15			2/15/23	#N/A
17	2/16/23	16			2/16/23	#N/A
18	2/17/23	17			2/17/23	#N/A
19	2/18/23	18			2/18/23	#N/A
20	2/19/23	19			2/19/23	#N/A
21	2/20/23	20			2/20/23	#N/A
22	2/21/23	21			2/21/23	#N/A
23	2/22/23	22			2/22/23	#N/A
24	2/23/23	23			2/23/23	#N/A
25
Sheet1

Cell Formulas
Range	Formula
E2:E24	E2	=A2
F2	F2	=IF(E2>TODAY(),#N/A,B2)
F3:F15	F3	=IF(E3<=TODAY(),B3,#N/A)
F16:F24	F16	=IF(E16<=TODAY(),B16,NA())