Marking Data Points on a Graph that are Out of a control limit

[Macro-wave]

I have a graph with Control Limits. I want to distiquish the data points that lie beyond certain upper and lower contol limits.

How do I go about doing this?

[Andy Pope]

Use additional series with formula to control which series the real data should be display by.

Search for Conditional charts

Or post you workbook if you need more help

[Macro-wave]

I was looking for a way to do it programatically, since the chart will alway be changing based on different user inputs.

The chart is already set up, so I don't want to just recreate the chart, I just want to add code to color points on the chart based on a condition.

[Andy Pope]

Code

Please Login or Register  to view this content.

Attached has both coded and dynamic solution