Chart with horizontal bands
Width of your band is Width = Max – MinGo to the ribbon to the Insert tab. Create Stacked Column chart.
Right click one column with your data. Choose Change Series Chart Type option.
Choose Line Chart.
Right click Min column and choose Format Data Series.
Nex change a fill to No Fill.
Right click Width column as well. Change Gap Width to 0%.
Your own Chart with horizontal bands is ready.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
