How To Make Stacked Bar Chart Excel?

Enter your data in columns with categories in the first column and series in the next 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

Use Switch Row/Column if the chart orientation is not correct

Add chart title, axis titles, and legend if needed

Format colors, labels, and gridlines as desired

Save your workbook

Suggested for You

Trending Today