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 (E-Mail Removed)> wrote in message
news:FB9398BF-42AE-479B-9B08-(E-Mail Removed)...
> 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 (E-Mail Removed)> wrote in message
> news:FB9398BF-42AE-479B-9B08-(E-Mail Removed)...
> > 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.
>
>
>