Line chart colour change if outside of target

[ipbr21054]

Evening,

I’m putting together a line graph/chart for my diabetes.
I’m currently looking to see how it’s possible to change the line colour if outside a certain range target.

I mean currently the line is Blue but when I enter a value that’s outside my max range target number then that part would change to say Red to alert me.

Any advise please or is this the wrong way to do this.

Thanks.

 

[Yongle]

Have a look at this link it contains an example very similar to what you want.
The trick is to use a formula (or manually) split the data into 2 series (the values above and below the threshold) and plot them using different colours

 

[ipbr21054]

Thank,i also came across that page last night

 

[ipbr21054]

I found this one to be great.

https://www.youtube.com/watch?v=hKjodKrzHIA

 

[ipbr21054]

Hi,

Im working through my sheet for my line chart but come across a problem.
I dont see why the input reading is only up to 21st.
I then added a second line of test readings but dont see that on the chart either.


Here is the workbook to share with you.

http://www.mediafire.com/file/rejp46dn936f43e/BLOOD_SUGAR.xlsx/file

Thanks