PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?TmFqYW0=?=
Guest
Posts: n/a
 
      30th Jul 2005
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 With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      30th Jul 2005
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two Data Sets: Stacked Column Chart Rainmaker Microsoft Excel Charting 1 11th Jun 2009 02:27 PM
How to show multiple data sets on one bar chart =?Utf-8?B?aXNpb21h?= Microsoft Excel Charting 1 11th Nov 2005 01:05 AM
To create a stacked column chart and group the stacked bars togeth =?Utf-8?B?SmFjcXVlbGluZQ==?= Microsoft Excel Charting 1 17th Feb 2005 11:05 PM
How can I plot multiple data sets in a stacked bar chart? =?Utf-8?B?SmVmZiBCZWNrZXI=?= Microsoft Excel Charting 1 13th Sep 2004 01:27 AM
Multiple Data sets on same chart gschimek Microsoft Excel Charting 1 24th Jun 2004 05:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:57 PM.