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.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

5. Chart Refinement The final step in creating an effective Excel dashboard is to refine your charts. Use the “Chart Formatting” tools to remove unnecessary elements like grid lines and borders.

Sometimes individuals in Microsoft Excel will create customs charts that are different from the original charts, for instance, a Lollipop chart.