shaded error bars in excel

summary: specify the upper/lower bounds using the error of your choice, plot those along with the primary data, then use transparency for the top bound to get the color effect and white-fill to remove what's below the bottom bound.

one comment to add to the below source is that depending on the order your data is loaded into the plot, you may need to switch up the order of the data series to obtain the correct appearance. however, top > data > bottom always in the order.


example:



source: https://nikkimarinsek.com/blog/tutorial-how-to-make-shaded-error-bands-in-excel