Excel doesn’t offer a floating bar chart of its own, and finding the option isn’t intuitive. First, we’ll create a line chart, and that chart type offers floating bars.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

A bar chart is useful when you want to do a quick side-by-side comparison of categorical data (e.g., countries, colors, types of software, modes of transport, marital statuses).

Click the first option under "Line" and click "OK." The second side scale is added and the Series2 data is converted into a line graph, which is superimposed onto the original bar graph.

A Chart is a graphical representation of data, such as a pie chart, bar graph, line graph, etc. Charts can make the information interesting, appealing, and easy to read for your audience.

Click "Insert" in Excel's menu bar. Click "Line" in the Ribbon's Charts tab. A drop-down menu opens. Click the first option from the menu. Tooltip text, when you highlight this option, reads, "Line.

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.