Forum Discussion
Bar graph stacked
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.
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.
