Highlight specific datapoints in X-Y graph

[NextYearSox]

I have an X-Y graph of sequential measurements made by three different people at random,

Column B: Measurement Number (1, 2, 3, ... ,n)
Column D: Measurement (0.21, 0.36, etc)
Column F: Measurer (Bob, Fred, David)

Right now, if I want to highlight the datapoints that Fred measured (for instance), I am manually clicking on the datapoint and changing its color. Is there an easier way to do this automatically without separating the data into three different groups of measurements?

 

[NextYearSox]

I was able to get something close ....

in Column H, I put the formula=If(F1="Bob",D1,"")
in Column I, I put the formula=If(F1="Fred",D1,"")
in Column J, I put the formula=If(F1="David",D1,"")

That allows me to plot three separate sets of data (which I want), but puts the "empty" values a datapoint at 0. Any way around this?

 

[AhoyNC]

Take a look at the following.

http://peltiertech.com/Excel/Charts/FormatMinMax.html

 

[NextYearSox]

That did the trick ... thank you.