|i need to create a stacked column chart where there are three sets of three stacked columns. Basically i have three variables the two axis would contain # of sales reps and total revenue the column separation or stacks would be the number of reps that hit a certain revenue in a certain number of years. This i can do fine if i am only looking at 2011. But i need to show 2010 and 2009 as well and have the columns stacked and next to each other. I know this sounds confusing. But i want three sets of three stacked columns. The first set would be in 2011,2010,2009 how many reps in total (vertical axis) hit 1m (horizontal axis) in 2,4 or 6 years (stacked column). The second set would be the same information except the on the vertical axis would be 2m. The third set 3m.|
Is it possible to group stacked columns like this???