Table tips

[rcocrane99]

Hey everyone I'm looking to transform my table and make it a little more advanced. I'd like to add 2 cells that can control the x axis date range so my plot does not represent all of my data at once, any tips on how to select that?

 

[Cubist]

You can try adding a "modified x" column that will return #N/A if it's not in the indicated range. Errors won't get plotted.

Book1
	A	B	C	D
1		Start	2
2		End	3
3
4	X	Modified X	Y
5	1	#N/A	8
6	2	2	5
7	3	3	3
8	4	#N/A	8
9	5	#N/A	3
Sheet4

Cell Formulas
Range	Formula
B5:B9	B5	=IFS((A5:A9>=C1)*(A5:A9<=C2),A5:A9)
Dynamic array formulas.