Conditional Formatting of a Chart

[NatalieEC]

Hi All,

I have a list of device numbers and beside the device number I have a value (let's say this value is a turn on voltage). In my original code, I used this value column with the rank and percentile option in data analysis. Then I created a scatter plot which has the turn on voltage on the x-axis and the percentile on the y-axis.

BUT now I have added a third column, which simply has a "Yes" or "No" representing if the device passed or not. What I would like to update on the plot is the colour. I still want the same values on the x and y axis, but now I would like each point on the scatter plot to be green or red depending on whether the device passed or not. The device doesn't necessarily fail because of the turn on voltage limits. There are other limits and parameters that determine this. For example, even if the turn on voltage was between its limits, it could have failed for another reason.

I included the code that I have now. It is working without the colour update. Do I need to use an array instead of a range? I am not sure how to go about this.

Thanks!

Please Login or Register  to view this content.

[NatalieEC]

Okay, now I have an update. I've learned about using Points(i). In the first point of the series which is in the rank and percentile table, I search for the value in the original data set to find the row number. Then I check in the third column to see if the device passed or not. Once I check that, I use .MarkerForegroundColor to change the colour of the point. However, whether it passes or not, all the points in the scatter plot are turned black.

Please Login or Register  to view this content.

[Sbarro79]

Maybe try something like this (I assumed that every point has yes or no value):

Please Login or Register  to view this content.

Not very smart, but who knows...

[NatalieEC]

Got it working!

I used these lines.

Please Login or Register  to view this content.