I would like to create a chart that has stacked AND clustered bars. The result that I am looking for is to have side-by-side bar columns for each year, e.g. one for total sales per year for each individual sales person, over a series of years. Within each bar column, I'd like to stack a breakdown of the data for each column, e.g., what products each individual sold for that particular year.

I can create a side-by-side bar graph and I can create a stacked bar graph. What I can't do is combined them into a single chart. Is this even possible? If so, how?

Thanks in advance for any help!!

Karen