How To Create A Stacked Bar Chart In Excel

To create a stacked bar chart in Excel, follow these steps: select the data, insert a bar chart, customize the chart design and axis options, and finally format the data series and chart elements to display a stacked appearance.

In the world of data analysis and visualization, Excel is a powerful tool that is widely used by professionals from various domains. One of the most popular chart types in Excel is the stacked bar chart, which allows you to display multiple data series stacked on top of each other for easy comparison. Whether you are a business analyst, a data scientist, or a student, knowing how to create a stacked bar chart in Excel can greatly enhance your ability to present and interpret data effectively. In this blog post, we will walk you through the step-by-step process of creating a stacked bar chart in Excel, so you can master this valuable skill and unlock new possibilities for data visualization.

How To Create A Stacked Bar Chart In Excel: Step-by-Step


Step 1: Organize Your Data

To create a bar chart on a worksheet, organize your data in columns or rows. Label the data for clarity. The first column should have the names to display on the chart, with subsequent columns holding the data to represent.

Next Step

Step 2: Select Data

Once the data is organized, left-click and hold, then drag the cursor to select the desired data for the chart. Don’t forget to choose headers and labels as well for comprehensive inclusion.

Next Step

Step 3: Insert Chart

This process can be done by navigating to the “Insert” tab in Excel Ribbon, selecting “Chart”, choosing “Column or Bar Chart” from the dropdown list, and then selecting “Stacked Bar” from the context menu.

Next Step

Step 4: Customize Chart

After creating your chart, customize it by adding labels, titles, and a legend. To do this, click on the chart and then the ‘+’ button. You can also change styles and colors from the “Chart Tools Design” tab.

Next Step

Step 5: Format Your Chart

In addition to adjusting colors, lines, effects, and text styles, the “Format” tab under “Chart Tools” allows you to modify gradients, shadows, opacity, and data labels. You can also add titles, legends, data tables, and customize axis properties for a visually appealing and comprehensible chart.

Next Step

Step 6: Save Your Work

Once you have finalized your chart, simply save it by selecting the diskette symbol or going to “File” then “Save As.” Pick the designated location and enter a file name for future reference.


In conclusion, creating a stacked bar chart in Excel can be a powerful tool for visually representing and analyzing data. By following the step-by-step instructions outlined in this blog post, you can confidently create your own stacked bar charts in Excel. Whether you are analyzing sales data, comparing different categories, or tracking progress over time, a stacked bar chart can provide valuable insights and make your data more accessible. With a little practice, you will be able to efficiently create and customize stacked bar charts to effectively communicate your findings to others. So, why wait? Start creating your own stacked bar charts in Excel today and unlock the potential of your data!

Table of Contents