How To Make A Stacked Bar Chart In Excel

To create a stacked bar chart in Excel, you need to organize your data in columns, select the data range, choose the “Stacked Bar” chart type, and customize the chart settings as per your requirement.

In today’s data-driven world, visualizing information in an easy-to-understand format is crucial for effective communication. One popular way to showcase data is through stacked bar charts, which allow you to compare multiple categories and their respective values in a single diagram. Excel, a powerful tool for data analysis and visualization, provides a simple yet robust solution for creating stacked bar charts. In this blog post, we will guide you step-by-step on how to make a stacked bar chart in Excel, equipping you with the skills to present your data in a visually impactful and informative manner. So, let’s dive in and unlock the potential of Excel to create stunning stacked bar charts!

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


Step 1: Prepare Your Data,

In Excel, input your data for the bar chart, with categories and their corresponding values in separate rows or columns. Ensure that the alignment of categories and values is accurate.

Next Step

Step 2: Select Data,

To create a bar chart, select the desired data range by clicking and dragging your mouse or using the Shift key with arrow keys, including all the cells you want to include.

Next Step

Step 3: Insert Stacked Bar Chart,

To quickly create a stacked bar chart in Excel, go to the ‘Insert’ tab, choose the ‘Column or Bar Chart’ button in the ‘Charts’ group, and select the ‘Stacked Bar’ option from the dropdown. The chart will be generated on a separate sheet.

Next Step

Step 4: Adjust Chart Elements,

In order to enhance your chart, simply click on it and utilize the ‘Add Chart Element’ button on the ribbon. This feature allows you to easily add, modify, or customize labels, titles, data labels, and legends for a more detailed and accurate representation.

Next Step

Step 5: Customize Chart,

You have the flexibility to customize your chart completely. From altering the color and style of bars to adjusting font and other formatting options, simply select the chart and utilize the ‘Format’ tab in the ribbon.

Next Step

Step 6: Save Your Work,

To prevent data and chart loss, save your spreadsheet by clicking ‘File’ then ‘Save’ or using the keyboard shortcut ‘CTRL+S’.


In conclusion, creating a stacked bar chart in Excel is a simple yet powerful way to visually represent and analyze data. By following the step-by-step guide outlined in this blog post, you now have the knowledge and skills to effectively create and customize stacked bar charts to suit your specific data visualization needs.

Remember that the use of stacked bar charts can help showcase the composition and comparison of multiple categories within a single bar, providing valuable insights and enabling better decision-making. With Excel’s intuitive interface and a wide range of customization options, you can easily create professional-looking stacked bar charts that effectively communicate your data findings.

Whether you’re presenting sales figures, survey results, or any other dataset, stacked bar charts can be an indispensable tool in your data analysis arsenal. So go ahead, experiment with different chart styles, colors, and labeling options to create visually appealing and impactful charts that effectively convey your message.

So, why wait? Dive into Excel and start creating impressive stacked bar charts that will not only impress your peers and clients but also provide valuable insights for your business or personal projects. Happy charting!

Table of Contents