View Single Post
  #9   Report Post  
Jon Peltier
 
Posts: n/a
Default

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