ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I group multiple sets of data for stacked bar chart? (https://www.excelbanter.com/charts-charting-excel/37848-how-do-i-group-multiple-sets-data-stacked-bar-chart.html)

Najam

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?

Jon Peltier

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