This activates the Format Data Series task pane. Click on the data series to select them.In the Labels section, click the Label Position drop down menu and select Low to move the vertical axis labels to the left of the chart.Ĥ.In the Format Axis task pane, scroll down and click on the Labels option to expand it.By default, the horizontal axis is selected. In the opened submenu, click on More options.In the Chart Elements menu, hover your cursor over the Axes option and click on the arrow next to it. Move the vertical axis labels to the left of the chart. This inserts a mirror bar chart into the worksheet.ģ. On the Insert tab of the ribbon, in the Charts group, click on the Insert Bar Chart button and in the opened menu, click on the second option, which is Stacked Bar, among the 2-D Bar charts. An important point here is to write the values of one of the data sets as negative numbers so that they appear on the opposite side of the vertical axis.Ģ. Enter and select the data that you will use to create the mirror bar chart. To create a mirror bar chart in Excel, take the following steps:ġ. If you prefer written instructions, then continue reading. Watch the video below to see how to create a mirror bar chart in Excel. In other Excel versions, there may be some slight differences in the described steps. The advantage of a mirror bar chart is that it illustrates two data sets side by side and therefore makes it easy to make comparisons and spot any differences between them. The chart resembles the reflection of a mirror, hence the name “mirror bar chart”. Mirror bar chart is a type of bar chart that comparatively displays two sets of data side by side along a vertical axis.
0 Comments
Leave a Reply. |