Line Chart with fixed Min and Max (blood sugar levels)

This is the standard first suggestion for conditional formatting chart information: https://peltiertech.com/conditional-...-excel-charts/

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

This is what I have asked you to do. It assists your helpers if they can see your data and its layout. Make sure you follow the instructions: desensitise it and add expected results (could be a hand-drawn image in your case).

Sorry I am late getting back to this.

Without some idea of where you are getting stuck, it is difficult to make any suggestion. It would probably help to upload a sample file with your starting data and any attempts you have made to follow Peltier's tutorial.

I find that a lot of charting questions in Excel end up being more about arranging the data in the spreadsheet, and this scenario is a good example of that. Notice that Peltier starts with the data in two columns (just as I would guess you have). Then he adds several helper columns with a formula like =IF("column B is between values in rows 1 and 2",value in B,NA()). These helper columns are then used to create the chart, where each column becomes its own data series that can be formatted however you would like.

And what was the solution? Please share for everyone's benefit.

Thanks for sharing.

Please mark the thread as solved.