How to Mirror Chart in Excel (2 Suitable Examples)

If you are looking for some special tricks to learn how to mirror chart in Excel, you’ve come to the right place. This article will discuss two suitable examples of creating mirror chart in Excel. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try yourself while you go through the step-by-step process.


2 Suitable Examples to Mirror Chart in Excel

In the following section, we will use two effective and tricky methods to mirror charts in Excel. We will mirror a bar chart in the first example. To create a mirror of a bar chart, at first, we organize our dataset, then create a stacked bar chart, and finally, customize the graph by adding graph elements and editing the graph layout. Next, we will demonstrate how to mirror a three-dimensional column chart. This section provides extensive details on these methods. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.


1. Mirror Bar Chart in Excel

Here, we will demonstrate how to mirror the bar chart. At first, we have to prepare a dataset containing monthly sales of two different products as shown below. Here, Let’s walk through the following steps to mirror the bar chart in Excel.

📌 Steps:

  • First of all, input the months in the range of cells B5:B16 and sales of different products of the corresponding date in the range of cells C5:D16. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Mirror Bar Chart in Excel

  • Now, we are going to insert a bar chart for our dataset.
  • First of all, select the range of the cells B4:D16.
  • Now, in the Insert tab, click on the drop-down arrow of the Insert Column or Bar Chart from the Charts group.
  • Then, choose the Stacked Bar Chart.

insert Chart in Excel

  • As a consequence, you will get the following bar chart.

  • Next, right-click on the Months in the Bar chart and select Format Axis.

click on Format Axis

  • Then, the Format Axis pane will appear on the right.
  • Next, check the Categories in reverse order to reverse the month’s order.

  • Next, you have to delete the gridlines and axes by pressing delete from your keyboard or uncheck Gridlines and Axes from the Chart Elements icon.
  • There, you will get the following bar chart.

  • You can format the axis by right-clicking the Months in the Bar chart and selecting Format Axis.

  • Then, the Format Axis pane will appear on the right.
  • Next, select Label Position, and from the drop-down menu, select Low.

select label position

  • As a result, you will get the following bar chart.

change the label position

  • Now, right-click on the Bar chart and select Format Data Series.

select Format Data Series

  • Therefore, the Format Data Series pane will appear.
  • Then, you have to reduce the Gap Width by 0%.

  • The Bar chart will look like this.

get the Mirror Chart in Excel

  • Now, you have to select the bar chart and select the Format tab.
  • Next, select the Shape Outline option. Select the White color as Theme Color.
  • Click on the Weight option and from the drop-down menu select 1 pt.

  • Therefore, the Bar chart will look like this.

  • Now, we are going to add graph elements. In Quick Elements, some elements are already added or removed. But you can manually edit the graph to add or remove any elements of the chart by using the Add Chart Element option. After clicking on the Add Chart Element, you will see a list of elements.
  • Next, you have to click on them one by one to add, remove or edit.
  • Or you can find the list of chart elements by clicking the Plus (+) icon from the right corner of the chart as shown below.
  • Here, you have to mark the elements to add or unmark the elements to remove.
  • So, you have to click on the right bar chart and select Data Labels and finally select the Inside Base option as shown below.

check the Data Labels

  • Next, you have to click on the left bar chart and select Data Labels and finally select the Inside End option as shown below.

check data labels for Item 1

  • Therefore the Bar chart will look like this.

  • Now, right-click on the left Bar chart and select Format Data Labels.

select the Format Data Labels

  • Therefore, the Format Data Labels pane will appear.
  • Then, you have to select Number in the Category option.
  • Enter 0 in the Decimal places.
  • Next, select the Red color number format in the Negative numbers option.
  • Type the following Format Code.
  • Finally, click on Add.

  • Therefore, you will be able to mirror the Bar chart as follows.

get customized mirror chart in excel

Read More: How to Mirror Table in Excel (4 Easy Methods)


2. Mirror 3-D Column Chart in Excel

Now, we will demonstrate how to mirror the 3-D Column chart. At first, we have to prepare a dataset containing monthly sales of two different products as shown below. Here, Let’s walk through the following steps to mirror the 3-D Column in Excel.

📌 Steps:

  • First of all, input the months in the range of cells B5:B16 and sales of different products of the corresponding date in the range of cells C5:D16. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Mirror 3-D Column Chart in Excel

  • Now, we are going to insert a 3-D Column chart for our dataset.
  • First of all, select the range of the cells B4:D16.
  • Now, in the Insert tab, click on the drop-down arrow of the Insert Column or Bar Chart from the Charts group.
  • Then, choose the 3-D Column.

insert chart

  • As a consequence, you will get the following 3-D Column chart.

  • To modify the chart style, select the Chart Styles icon and then, select your desired style option from the Chart Styles group.

get the mirror 3-D Column Chart in Excel

  • Therefore, you will be able to mirror the 3-D Column chart as follows.

get the customized mirror 3-D column chart in Excel

Read More: How to Mirror Data in Excel (3 Easy Ways)


💬 Things to Remember

✎ Before inserting a bar chart, you must select anywhere in the dataset. The rows and columns will need to be manually added otherwise.

✎ In the Negative Numbers option, selecting Red color will automatically create a format code for the Red color number, but you must type Black instead of Red in the code to convert the numbers to black.


Conclusion

That’s the end of today’s session. I strongly believe that from now you may be able to mirror chart in excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo