Forum Discussion

5880forre's avatar
5880forre
Copper Contributor
Jul 01, 2020

Shading a line chart above a set threshold only

Hopefully someone can assist, YouTube has not been as helpful as usual! I am attempting to format a line graph with shading. I need to track a daily temperature reading in degrees and I would li...
Charting
excel
Formulas and Functions
training
hynguyen's avatar
hynguyen
Iron Contributor
Jul 02, 2020

5880forre Please view the attached chart. Currently I manually set both primary and secondary axis's lower bound to 20 and upper bound to 30 to enlarge the shading area. You can edit them to whatever bound you want but need to change both axis with  the same scale.

Resources