spot_img

Chart with horizontal bands

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.data table values bandsWidth of your band is Width = Max – Min

Go to the ribbon to the Insert tab. Create Stacked Column chart.

Chart with Horizontal Bands basic chart

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

change chart type

Choose Line Chart.

Line Chart

Right click Min column and choose Format Data Series.

Format Data Series

Nex change a fill to No Fill.

No Fill

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

Zero Gap Width

Your own Chart with horizontal bands is ready.

Chart with Horizontal Bands

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell