How to create Mirror Bar Chart?

  1. Mirror Bar Chart

Excel’s Mirror Bar Chart feature is helpful for displaying two sets of data side by side in a format that’s both aesthetically pleasing and straightforward to compare. An example of a mirror bar chart would be a graph in which two bars, each representing a different set of data, are joined at the centre. In Excel, there are specific procedures that must be followed in order to produce a mirror bar chart. Follow along as we show you how to make a mirror bar chart from scratch.

Uses of mirror bar charts in Excel:

  • Comparing two sets of data side-by-side
  • Showing the difference between two values within a larger dataset
  • Highlighting changes in data over time

How to make a mirror bar chart in excel?

In order to create mirror bar chart excel , do the following steps:

  1. Take sample data. We take Product A data with a (-) sign and Product B data with a (+) sign.Mirror Bar Chart
  2. Go to the ribbon, select Insert, and select your chart type from the chart group.Mirror Bar Chart
  3. Select Chart type as 2-D Bar.Mirror Bar Chart
  4. The chart looks below.Mirror Bar Chart
  5. To change the category in reverse on the vertical axis, right-click on the axis and select Format Axis.Mirror Bar Chart
  6. After that in the Axis Options give a checkmark on the ‘Categories in Reverse Order’ box.Mirror Bar Chart
  7. To remove the horizontal axis, click on Axis and press the Delete option.Mirror Bar Chart
  8. To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline. Mirror Bar Chart
  9. To change the axis label position, right-click on the Axis and select Format Axis, in Format Axis select Axis Option and choose Labels. Here click Low in the Label Position.Mirror Bar Chart
  10. To change the gap width in the bar, right-click on the chart and select Format Data, in Format Data Series select Series Option and change the gap width to 0%.Mirror Bar Chart
  11. Now we give a white outline in the bar to distinguish one bar from another. Select the bar, go to Format ribbon, choose shape outline as white and weight as 1pt.Mirror Bar Chart
  12. Do the same step for the other side of the bar Select the bar, go to Format ribbon, choose shape outline as white and weight as 1pt.Mirror Bar Chart
  13. To change the color, select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.Mirror Bar Chart
  14. Follow the same step to change the color of the other part of the chart. Select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.Mirror Bar Chart
  15. To give Data Labels click on your chart and select the + button to give your Data labels. Select Data labels and click on Inside End for the first chart and Inside Base for the second chart or any other option.Mirror Bar Chart
  16. To change the legend position, right-click on the chart and select Format Legend, in Format Legend select Legend Option and choose Top.Mirror Bar Chart
  17. Change 2nd data label Number Format and color, follow the below steps. Choose Number Category, Decimal places, negative number color, and Format code as highlighted in the image.Mirror Bar Chart
  18. The chart looks below.Mirror Bar Chart

Application of Mirror Bar Chart in Excel in Dashboard Reporting

 

Data Visualization Charts and Graphs
Data Visualization Charts and Graphs

Here are some uses of Mirror Bar Charts in dashboard reporting:

  1. Comparing Positive and Negative Values:
    • Ideal for showcasing data that have inherent positive and negative aspects, such as profits and losses, assets and liabilities, or revenue and expenses, highlighting the balance or disparity between them.
  2. Gender Comparison in Demographic Studies:
    • Useful for comparing demographic data, such as population, education level, or income, between genders, with one direction representing male and the other representing female.
  3. Before and After Analysis:
    • Compares metrics before and after a specific event or intervention, such as customer satisfaction, employee productivity, or sales figures, before and after a new policy or campaign.
  4. Opinion Polls or Survey Results:
    • Displays the results of opinion polls or surveys, contrasting agree vs. disagree, satisfied vs. unsatisfied, or recommend vs. not recommend responses.
  5. Product or Service Comparison:
    • Compares two products or services based on various attributes or performance metrics, making it easy to assess strengths and weaknesses side by side.
  6. Competitor Analysis:
    • Visualizes a company’s performance metrics against a key competitor’s, across different areas like market share, growth rate, customer satisfaction, or product quality.

Mirror Bar Charts are particularly effective for these scenarios as they provide a straightforward visual comparison that emphasizes the relationship or contrast between two sets of data, making the differences and similarities immediately apparent.

For ready-to-use Dashboard Templates:

    1. Financial Dashboards
    2. Sales Dashboards
    3. HR Dashboards
    4. Data Visualization Charts

 

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories