Gradient Lines on Value, not Percentage

Hey All,

So I've got the gradient line chart going, however is it possible to base the gradients on actual values and not percentages? See the problem I'm having on the 'Combined' tab of the attached workbook. When there's no data, the gradient is skewed. I can adjust this each day, but to do it right calls for a permanent solution.

Is this possible? I've seen articles for bar charts, but not line. And applying the same techniques doesn't work.

Thanks for your time,

You can use this formula in cell C2 of the Combined sheet (changes in red compared with your existing formula):

=(IFERROR(AVERAGEIF(data_Jan2021!$A$2:$A$90,B2,data_Jan2021!$B$2:$B$90),NA()))

and copy down ONLY for the January dates. It will return the error message #N/A, which your graph will ignore, but you could use conditional formatting to turn the font colour to white if you don't want to see the error.

Is that what you were looking for?

Hope this helps.

Pete