Set up your data like this:
A-Voice B-Voice A-Email B-Email
x
April 10 10
8 12
x
May 11 9
9 11
x
June 12 8
10 10
x
The rows with X in the first column have no values in the last four
columns, and you should replace the X with a space (not a blank cell).
Select the range and make a stacked column chart. Double click one of
the columns, and on the Options tab, change Gap Width to zero. The blank
rows provide gaps between certain pairs of stacks.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
sachinattri wrote:
I dont understand this. Sorry to be ignorant. I have the data under
following columns
Country A Voice - Country B Voice - Country A Email - Country B Email
and then these 4 columns headings have numbers under them By Month.
let's say for Apr-May-Jun
How do I get 2 stack columns side by side, showing Country A Voice &
Country B Voice and the second stack next to it for Country A Email &
Country B Email for April, then May and then June.
Thanks
/sa