Changing colors of individual points in line chart based on values in cell

[Yemjay]

Hi all

This is kind of difficult to explain, so i have uploaded an excel sheet with my requirement.
My summarized requirement is :

I have a line chart with 5-6 points. This line chart corresponding to the last points requires a different color (because that is a projection). I can manually select that point in chart and give a color of my choice, but i want to do this using macros. If a particular point have a value greater than say 0, then the line chart corresponding to that point should have its color changed to say red

Reading this alone might not get you anywhere. Hence I recommend you to go through the uploaded excel sheet as well..
Thanks in advance

Yemjay

 

[Luke M]

Hi Yemjay,

What you want is commonly known as conditional formatting for charts. Most of the time, including this case, you can achieve the goal with some extra formulas and how you build the chart. Check out the attached.

More reading:
http://peltiertech.com/conditional-formatting-of-excel-charts/

 

[Yemjay]

Thanks a lot Luke