# Conditional Graphing Based on an Array

#### mdorman

##### New Member
Problem.xls
ABCDEF
2StartFinish
3Time15
4
5StartFinishNameFinish
6A15B2
7B32E3
8C15F3
9D85H4
10E13I4
11F33J2
12G15L3
13H84 #N/A
14I14 #N/A
15J32 #N/A
16K15 #N/A
17L83 #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!

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Hi,

HTH

Replies
5
Views
454
Replies
1
Views
135
Replies
3
Views
1K
Replies
0
Views
636
Replies
4
Views
2K

1,203,094
Messages
6,053,507
Members
444,667
Latest member
KWR21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back