In this Excel tutorial you will learn how to create a chart with horizontal bands.
First prepare some data. You need values and bands. You need min and max value of the band.
Width of your band is Width = Max - Min
Go 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.