Hello everyone,

I'm creating an Excel sheet with blood sugar levels to show in a line chart.

By watching the tutorial by Leila Gharan about showing the Min and Max in the Chart it gives me a start, but what I really need is a fixed Min and Max.
So I would like to have the numbers in the chart turn red if they are <4, green between 4-10, and red by >10.
Ofcourse I can set the conditional format in the data column, but I would like to see the red/green in the chart as well.

How can I do this?

Thank you,
Yolanda, NL