In this Excel tutorial, you will learn how to create a chart with horizontal bands.
How to create bands in Excel?
First, prepare some data. You need values and bands. You the need min and max values of the band.
The width of your band is Width = Max - Min
How to insert a band chart?
Go to the ribbon and the Insert tab. Create Stacked Column chart.
Right-click one column with your data. Choose the Change Series Chart Type option.
Choose a Line Chart.
Right-click on the Min column and choose Format Data Series.
Next, change the fill to No Fill.
Right-click the Width column as well. Change the Gap Width to 0%.
Your own chart with horizontal bands is ready.