I am trying to select data for a bar chart. In Column B i have one of two
labels: ES or ZN. I would like the bar chart to plot only the values in
corresponding rows of column Q that have "ES" in the B column. Thus if:
B Q
1 ES 2
2 ZN 4
3 ES 3

The the chart should only show 2 bars: one for Q1 (2) and one for Q3 (3).

What would be the formula that i could write in the Chart Data Range box
that would accomplish this?

Thanks

EG