Quick, clean, and to the point

Daylight hours from sunrise to sunset

Daylight hours from sunrise to sunset chart

This chart is an example of a column chart that uses a "floating bar" technique to plot daylight hours on the chart in way that makes the bars look like the are floating above the horizontal axis. The trick in this case is to create three helper columns that do not exist in the original data: daylight, evening, and hrs. The video here walks through this process.

Original data

Original data for sunrise and sunset chart

Data with helper columns

Data with new helper columns

Chart type 
Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.