How do I group multiple sets of data for stacked bar chart?

N

Najam

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?
 
J

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Stacked Bar Chart 1
Stacked Line Chart 3
stacked column chart 4
column charts with set set of data 0
How can I combine a stacked column chart and line chart? 1
Stacked bars with textlegends in each stacked bar 7
Stacked Chart (per month per year) 1

Top