Summary

One of the charts you'll see around is a so called "floating column chart", where columns rise up off the horizontal axis to depict some sort of value range. There are many ways to make this kind of chart in Excel, and Jon Peltier has a very comprehensive run-down here.

This page describes just one approach, where you make a line chart with two data series (one high, one low) and then use "up/down bars" to create the floating columns. The advantage of this approach is simplicity. There is no need to add calculations and a ghost data series to float the columns, as you'll see in other examples. 

The data used to make the chart on this page looks like this:

Data used to create floating column chart with up down bars

How to make this chart

  1. Place cursor in data and insert a line chart:
    Insert line chart from ribbon
  2. Select the standard 2D option:
    Select basic 2d option
  3. The chart as inserted:
    Chart as inserted
  4. Select the chart and add up/down bars:
    Select chart and add up/down bars
  5. Select each data series in turn and set line to "no line":
    Select each data series and set to no line
  6. Chart after setting both data series to "no line":
    After setting each data series to "no line"
  7. Select and delete legend
  8. Select vertical axis and set bounds to 100 and 55:
    Format axis to set upper and lower bounds
  9. Select up/down bars and change color and border as desired
  10. Final chart before title and sizing:
    Final floating column chart before title, sizing, font, etc.
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.