Creating a Combination Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 29 Aug 2006 18:43 GMT

I have 3 data series. I would like to make Series 1 a clustered column, and
Series 2 & 3 a stacked column. Is that possible? If so, could someone
kindly tell me how to do it? Thanks in advanced for any help.

Reply to this Message

Franz Verga - 29 Aug 2006 19:10 GMT

> I have 3 data series. I would like to make Series 1 a clustered
> column, and Series 2 & 3 a stacked column. Is that possible? If so,
> could someone kindly tell me how to do it? Thanks in advanced for
> any help.

Hi Bob,

First of all built the chart as a clustered column with the 3 series, than
select series 2 right click on it, select Chart Type and select a a stacked
column type; repeat for series 3.

Signature

(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

Bob - 29 Aug 2006 20:49 GMT

Franz,
Thanks for your help. Unfortunately, I already tried your suggestion, but
it did not work. Apparently, Excel allows only certain chart types to be
combined. And having a cluster bar and stacked bar on the same chart is not
an allowable combination. Thanks again.
Regards, Bob

> > I have 3 data series. I would like to make Series 1 a clustered
> > column, and Series 2 & 3 a stacked column. Is that possible? If so,
[quoted text clipped - 6 lines]
> select series 2 right click on it, select Chart Type and select a a stacked
> column type; repeat for series 3.

Reply to this Message

Jon Peltier - 30 Aug 2006 04:33 GMT

Try one of the examples here:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Bernard Liengme's page shows one example with stacked and unstacked adjacent
columns, as opposed to multiple adjacent stacked columns.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

>I have 3 data series. I would like to make Series 1 a clustered column,
>and
> Series 2 & 3 a stacked column. Is that possible? If so, could someone
> kindly tell me how to do it? Thanks in advanced for any help.

Reply to this Message

Bob - 31 Aug 2006 02:17 GMT

Jon,
Thanks for the tip! Although Bernard Liengme's solution is not exactly what
I was looking for, it gets me closer to what I am trying to achieve (i.e.,
1st bar clustered; 2nd & 3rd bars stacked on one another). With some slight
modifications to Bernard Liengme's solution, however, I just might be able to
achieve my objective.
Thanks again for all your help.
Regards, Bob

> Try one of the examples here:
>
[quoted text clipped - 14 lines]
> > Series 2 & 3 a stacked column. Is that possible? If so, could someone
> > kindly tell me how to do it? Thanks in advanced for any help.

Reply to this Message

Jon Peltier - 01 Sep 2006 13:06 GMT

As I recall, Bernard's solution was 1st & 2nd stacked and 3rd clustered.
Just delete a different column from the original, which had 1&2 stacked next
to 3 & 4 stacked.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Jon,
> Thanks for the tip! Although Bernard Liengme's solution is not exactly
[quoted text clipped - 27 lines]
>> > Series 2 & 3 a stacked column. Is that possible? If so, could someone
>> > kindly tell me how to do it? Thanks in advanced for any help.

Reply to this Message