Tag Archives: bar chart

How to Create Multi-Category Chart in Excel

Multi-category chart

Multi-category chart or multi-level category chart is a chart type that has both main category and subcategory labels. This type of chart is useful when you have figures for items that belong to different categories. continue reading >>

How to create a combined clustered and stacked bar chart in Excel

Combined clustered and stacked bar chart

When visually comparing the values of multiple items, if the value of one item is greater than the total values of all the other items, you may want to emphasize it. You can do so by displaying the largest value in one bar and grouping the smaller values together in another bar in a combined clustered and stacked bar chart. continue reading >>

How to create a mirror bar chart in Excel

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. The chart resembles the reflection of a mirror, hence the name “mirror bar chart”. 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.
continue reading >>

How to show percentages on three different charts in Excel

how-to-show-percentages-in-excel

Percentage is one of the most common ways of expressing a proportion. In Excel, you can use three different charts, namely a pie chart, a doughnut chart and a bar chart to show percentages of a whole. continue reading >>