Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I group multiple sets of data for stacked bar chart?
I want to create a stcked column chart with 4 groups of dataset each
containing 3 values. 3 values should be stacked in a column and each column should represent a group. Can anyone please help me? |
#2
|
|||
|
|||
Arrange your data like this. Keep the top left cell blank, then create
the stacked column chart with series in columns. Bottom Middle Top Group 1 X X X Group 2 X X X Group 3 X X X Group 4 X X X - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Najam wrote: I want to create a stcked column chart with 4 groups of dataset each containing 3 values. 3 values should be stacked in a column and each column should represent a group. Can anyone please help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i import multiple data sets at one time? | Excel Discussion (Misc queries) | |||
Two data sets, one average | Charts and Charting in Excel | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
multiple x axis data | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |