stacked column charts

Microsoft Microsoft excel 2007 full vers...
June 17, 2011 at 11:04:30
Specs: Windows XP
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???


See More: stacked column charts

Report •


#1
June 17, 2011 at 11:36:29
i guess what i am looking to do is a stacked and clustered chart together

Report •

#2
June 18, 2011 at 01:12:53
You could try using some software, like MS Excel for example.

Nigel

Mobo: Asus P7P55D LE
OS: Microsoft Windows 7 Professional OEM
CPU: Core i5 750 @ 2.67 GHz
RAM: Corsair Dominator DHX+ DDR3 1600MH 4GB
GPU: Sapphire 4870 D


Report •

#3
June 18, 2011 at 03:36:05
i am using excel 2007 guess i forgot to mention that.. but i am wondering if this is even possible in excel

Report •

Related Solutions

#4
June 19, 2011 at 02:38:08
Perhaps posting in the Office/software forum may be better, with all relevant info included, such as how data is arranged.

Nigel

Mobo: Asus P7P55D LE
OS: Microsoft Windows 7 Professional OEM
CPU: Core i5 750 @ 2.67 GHz
RAM: Corsair Dominator DHX+ DDR3 1600MH 4GB
GPU: Sapphire 4870 D


Report •

#5
June 19, 2011 at 03:33:27
i put how data is arranged and this is tagged as excel.. if there is no answer i will just try another way

Report •

Ask Question