Bar graph stacked

[Tamras1972]

How would I create a graph that shows how many 1s, 2s, and 3s, per column with the following data?

2	3
3	2
2	2
2	1
2	2
1	2
3	2
3	1
1	1
3	2
2	2

and the bar to look like this, like the green = 3, blue = 2, and 1 = yellow.  Each bar = column 
Left bar has 4 counts of 3, 5 counts of 2, and 2 counts of 1.

[#2 · Accepted solution]

@Tamras1972 See attached!

You need to summarise the data with COUNTIF first.

[#3]

@Riny_van_Eekelen Perfect!  Thank you.  I knew it was COUNTIF but I kept trying to do it within the chart's data settings. I didn't think to create a new table.