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? |
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? |
All times are GMT +1. The time now is 05:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com