Side by side comparison bar chart

To compare two sets of data, you can create various comparison charts, such as a butterfly chart, mirror chart, tornado chart, etc., or a double-sided chart. However, comparing the values in opposite directions is not always convenient. In order to display two datasets, you can use Excel to create a side-by-side bar chart, also known as a double bar chart.

How to create Waterfall chart

The waterfall chart, also known as the cascade or bridge chart, shows the positive or negative change of the initial value under the influence of various factors, such as time. The main purpose of this chart is to show the viewer how the value has increased or decreased over a certain period or under the influence of certain factors:

How to add a vertical line to the scatter chart

Vertical lines are usually added to the chart to highlight the current date, a critical date, or a deadline. There are many ways to add a vertical line to the existing chart. Errors bars are the easiest way to add a vertical line to a scatter plot. See how to add a vertical line to a line or bar chart or a horizontal line to a scatter plot, line, or column chart:

How to add deviations into your chart

Sometimes you can give your charts a more impressive view by showing deviations of some real process from its expected flow.

How to create a simple Bullet graph in Excel

A bullet graph (the name by its inventor Stephen Few) or bullet chart (in Microsoft office) generally is used to display progress towards the specific target:

How to add a vertical line to the line or bar chart

To show progress, highlight current or any date, or demonstrate the difference between the target value and the actual one, you can add bullets to the chart, horizontal or vertical lines:

How to create bar chart of the survey results

Surveys are used to collect opinions, preferences, and choices of the target audiences. They can be used to provide information that will help to make better business decisions. Surveys can help forecast demand and help businesses better prepare for the future.

How to create one chat of split bars or small multiple bars in Excel

It is often necessary to visualize the results of voting or polls in which the answers belong to different scales. For example, when collecting data on preferences, such as choosing from the proposed persons, teams (parties); applications, browsers; gadget models; food, colors; etc. See how to organize a team color preferences survey in Outlook.

Create bidirectional bar chart in Excel

A bidirectional chart, also known as a two-sided bar chart, is used to compare two (rarely more) sets of data side by side along the horizontal axis. Unlike other similar charts, such as the divergent chart (butterfly, mirror, tornado, etc.) and the Likert scale chart, the bidirectional histogram bars start on opposite sides and are directed toward each other.

Glossy Gantt chart with a vertical line

If you need to create a simple Gantt chart, see Creating a Gantt chart or Gantt chart with progress. To add events to your Gantt chart, see Progress Gantt chart with events. This tip will help you to extend those charts by a vertical line that shows the current date.