Conditional Formatting Graph Markers?

[rileycarterllc]

I am trying to recreate a line graph that contains UCL and LCL. However, the markers that are outside the limits are formatted differently. I know that I can do this manually. However, given that this graph will need to be refreshed monthly is there a way to conditionally format the markers?

The graph would only contain 4 lines (UCL, Mean, LCL, Goal). I want to format points based on whether they are outside the limits (one format), above average (another format), and below average (final format).

Thank you!!!!

 

[VoG]

Take a look at Conditional Charts http://peltiertech.com/Excel/Charts/ChartIndex.html

 

[rileycarterllc]

This PERFECT! Thank you soooo much!