Chart with horizontal bands

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.

data table values bands

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.

Chart with Horizontal Bands basic chart

Right-click one column with your data. Choose the Change Series Chart Type option.

change chart type

Choose a Line Chart.

Band Line Chart

Right-click on the Min column and choose Format Data Series.

Format Data Series

Next, change the fill to No Fill.

No Fill Band Chart

Right-click the Width column as well. Change the Gap Width to 0%.

Zero Gap Width

Your own chart with horizontal bands is ready.

Chart with Horizontal Bands