Home |
Search |
Today's Posts |
#9
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
Connect multiple columns in 1 row to another? | New Users to Excel | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |