Grouping Multi-year values by category in a chart

**jdrinnin** · 10-06-2011, 12:44 PM

Help! I would like to graph three different years of values by specific categories. For example: Product Group A revenue and profit in a stacked bar for years 2010,2011, 2012 grouped together, Product Group B revenue and profit in a stacked bar for years 2010, 2011, 2012, also grouped together and so forth. Any guidance on how I can accomplish this?

And, I have Excel 2003.

**cdotyii** · 10-06-2011, 01:37 PM

Does this help?

**jdrinnin** · 10-06-2011, 02:12 PM

Thanks for answering but sadly no, this does not help. I want to stack profit and revenue and keep Product A for '10, '11, and '12 grouped together and so on.