How To Make A Stacked Bar Chart In Excel?

Enter your data in a table with categories in one column and series in separate columns

Select the entire data range

Go to the Insert tab

Click the Bar Chart or Column Chart dropdown

Choose Stacked Bar or Stacked Column

If needed, use Switch Row/Column on the Chart Design tab

Add or edit the chart title

Format axis labels, legend, and colors as needed

Adjust data labels if you want values shown on the bars

Resize or move the chart as needed

Suggested for You

Trending Today