Conditional Graphing Based on an Array

[mdorman]

Problem.xls
	A	B	C	D	E	F
2		Start	Finish
3	Time	1	5
4
5		Start	Finish		Name	Finish
6	A	1	5		B	2
7	B	3	2		E	3
8	C	1	5		F	3
9	D	8	5		H	4
10	E	1	3		I	4
11	F	3	3		J	2
12	G	1	5		L	3
13	H	8	4			#N/A
14	I	1	4			#N/A
15	J	3	2			#N/A
16	K	1	5			#N/A
17	L	8	3			#N/A
Sheet2

Fair winds has helped me with the Array formula in column E (which works great). I've already found many applications.

Next, I would like to graph columns E and F. The problem is i want to only graph those values that meet the criteria i choose. That is, if i enter "5" in cell C3, i'd like it to graph only rows 6 through 12 of column E and F. If i enter, "7" in cell C3, it should graph rows 6 through 17 (because all meet the criteria).

If i graph all rows currently, the graph will have blank space for the rows that do not meet the criteria (in this case, rows 13 through 17).

Thanks to Fairwinds for helping with the array, and thanks in advance to anyone who can solve this one!

 

[Krishnakumar]

Hi,

For Dynamic Charts click here

HTH