Enter your data in a table with categories in one column and series in adjacent columns
Select the entire data range, including headers
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 data labels if needed
Format colors, legend, and gridlines as desired
Adjust the axis scale and chart layout if necessary
Save your workbook