LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
how do I filter for 1 variable in multiple columns California Excel Worksheet Functions 1 March 18th 05 10:36 PM
Connect multiple columns in 1 row to another? tb New Users to Excel 1 March 4th 05 09:57 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
Filtering Text Data from Multiple columns Brad Excel Worksheet Functions 6 January 1st 05 03:32 PM


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"