Is it possible to create a chart that combines the "clustered column" type
with the "100% stacked column" type? That is, I want to be able to compare
two different sets of data, where each set is represented with "100% stacked
column" bars.

Example:
Two sets of data (S1,S2), each set has 5 (identical) questions (Q1-Q5), with
4 possible answers. I want to compare Q1 in S1 with Q1 in S2, Q2 in S1 with
Q2 in S2, ..., all in the same chart.

Therese -

You should be able to adapt one of these to your needs.

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Therese Palm" <Therese wrote in message
...
Is it possible to create a chart that combines the "clustered column" type
with the "100% stacked column" type? That is, I want to be able to compare
two different sets of data, where each set is represented with "100%
stacked
column" bars.

Example:
Two sets of data (S1,S2), each set has 5 (identical) questions (Q1-Q5),
with
4 possible answers. I want to compare Q1 in S1 with Q1 in S2, Q2 in S1
with
Q2 in S2, ..., all in the same chart.

Thanks!

/therese


"Jon Peltier" skrev:

Therese -

You should be able to adapt one of these to your needs.

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Therese Palm" <Therese wrote in message
...
Is it possible to create a chart that combines the "clustered column" type
with the "100% stacked column" type? That is, I want to be able to compare
two different sets of data, where each set is represented with "100%
stacked
column" bars.

Example:
Two sets of data (S1,S2), each set has 5 (identical) questions (Q1-Q5),
with
4 possible answers. I want to compare Q1 in S1 with Q1 in S2, Q2 in S1
with
Q2 in S2, ..., all in the same chart.