I would like to display multiple stacked columns in the same excel graph.
Essentially, the purpose is to compare what categories of tasks each member on my team is performing on a weekly basis.
so for each week, I have 6 individuals, who each are working on varying amounts of a possible 6 different tasks. I have multiple other situations where i need to use this within the same excel doc, but i will use this as an example
I have used the method outlined here in the past: http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/
the problem with that method is that is does not scale well for larger data sets over time, it becomes pretty messy working with more than 2-3 indivuals. It also does not account for situations where the data being distributed (the names of the tasks) are exactly the same for each column (team members). To use that method for my team across 4-6 graphs would create some massive ugly tables that are not easy manage.
I am looking for a way to create this graph in a somewhat easy to maintain manner, rather than creating a sprawling/massive ugly set of tables.
thanks in advance