Cara membuat grafik di excel 20135/25/2023 ![]() 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. |