Quote Originally Posted by JBeaucaire View Post
OK, I realized your cell D5 was critical, too. So I built in a check into the formulas in N7-N14 to watch that cell, too.

When I parse out the value in E2, it's equivalent to column F on Sheet5, right? In that case, based on the choice in D5, the data in green now flows from column F for that value.

I added the missing 2320 chart at the bottom of Sheet5 and it needs your actual part # and values in the chart. (yellow cells) But the sheet4 green cells are watching that part already, so they'll work once you put those values in.

Thanks JB
I get it, but not really


I have another one posted over on the Excel charts section, involving a drop down list of 43 staff, and data being pulled from another sheet depending on the name chosen then charted out for performance.

stephen