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?

To create a chart with horizontal bands in Microsoft Excel, follow these steps:

First, prepare some data. You need values and bands. You then 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 a 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

With these steps, you should be able to create a chart with horizontal bands in Microsoft Excel. You can further customize the chart by changing the font, color, and other formatting options, as well as by adding additional data and formatting the axis.

See also  How to use Sparklines in Excel