I am trying to create a simple stacked bar chart in Excel 2010 but there must be a problem with the way my spreadsheet is set up, because it results in individual bars rather than 1 stacked bar. I have a column for reason and a column for count.

reason count

picking error 4
short shipped 3
over shipped 2
packaging 2
wrong customer 1
wrong carrier 1

(I would sell my soul to have the chart wizard back...)

Thanks in advance,

Leah