I am interested in creating a scatterplot of percentages and dates but only of those with a specific value in a seperate row. I'm not sure how to do this in Excel 2007.

A B C
1 May June July

2 Big Small Big

3 10 15 20


Ok, this is just for demonstration purposes. I would want to plot a scatterplot with X values as Row 1 (the month) and Y values as row 3. The catch is, I only want to plot X's and Y's for those columns with Big in row 2. THis is a much more simplified version of what I'm actually trying to do, and I'm attempting to avoid having to sort this every time I add new data. Is there a way to chart only If row 2=Big (or really, to chart series 1 if row2=big and series 2 if row2=small).

Thanks.