Excel Stacked Bar Chart Show Percentage And Value
If you are looking for a way to display data in a visually appealing way, then Excel stacked bar chart may be the solution for you. This chart type allows you to show the relationship between your data sets while also displaying their individual values and percentages. In this article, we will show you how to create a stacked bar chart that shows both percentage and value.
Step 1: Prepare Your Data
The first step in creating a stacked bar chart is to prepare your data. For this example, we will use the following data set:
| Month | Apples | Oranges | Pears |
|---|---|---|---|
| January | 20 | 15 | 10 |
| February | 25 | 20 | 5 |
| March | 30 | 10 | 15 |
Step 2: Create the Chart
Once you have your data prepared, you can create the stacked bar chart. To do this, select your data and go to the Insert tab on the ribbon. From there, choose the Stacked Bar Chart option.
Step 3: Add Data Labels
Next, you will want to add data labels to your chart. To do this, right-click on one of the bars and choose the Add Data Labels option. This will add the values of each bar to the chart.
Step 4: Show Percentage
Now, we will show the percentage of each data set on the chart. Right-click on one of the bars and choose the Format Data Series option. In the Format Data Series pane, go to the Series Options section and select the Percentage option.
Step 5: Customize Your Chart
Finally, you can customize your chart to make it look exactly how you want it. You can change the colors, fonts, and titles by selecting the chart and going to the Chart Tools tab on the ribbon.
Conclusion
Creating a stacked bar chart that shows both percentage and value in Excel is a great way to display your data in an organized and visually appealing way. Follow these steps to create your own chart and customize it to fit your needs.