Stacked bar chart filling up to 100%. Sometimes, you’ll want to compare your data to a total, be it a whole number or simply a 100% value.

To create a bi-directional mirror bar chart in Excel, you will have to start with the Stacked Bar In the 2-D Bar section. Here are the detailed steps to be followed.

Four types of graph are available: line graph, bar graph, stacked bar graph and area graph. Use the pulldown menu (top right) to select a type. Only graph types are shown that fit the data selection.