combining stacked with side-by-side bar

[Guest]

I need a graph which has a combination of horizontal bars (could do vertical
as well, though doubt it matters for whether this can be done), where for
each series, one of the bars is a stacked, two data point bar, and the one
NEXT to it is a single data point. In other words, I have the following data:

Type 1 Type 2 Type 3
EuropeA
EuropeB
US A
US B

There are more types, but this is the example. I need Type 1 to be 2 bars,
one with a stack of Europe A and B, and next to it, a stack of US A and B.
Then I need Type 2 as the next category to show two similar
side-by-side/stacked bars.

Possible? How?
Thx

 

[Andy Pope]

Hi,

The examples are for columns but should be adaptable for bars.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Guest]

Andy, thanks much. As you've done so in the past, you're a fountain of
knowledge.

Have structure to where I have my data showing as two separate stacks, with
one being one value, and the other being two values. Only issue is the
examples get me to the point where I have separated stacks. Any way of
moving each set of two stacks closer to one another? In other words, I want
each two stacks to be touching, and then a gap, and then the next stack. The
category labeling issue which I run into using the MS example (the fact that
the labels show up on every other stack) I can solve by simply doing text
boxes between the two stacks, and taking out tick marks on the axis. But I
need to have each two stacks come together, so that they are clearly showing
as being from the same category. I have '07, and see some overlapping and
other parameters, but this moves each stacked section away from the one below
it. What I want to do is affect the stacks as whole stacks, with relation to
the next stack.

Any ideas? I'm almost there, and excited I may actually have this happen.

 

[Andy Pope]

Hi,

Set the gap width to zero, this will make the stacks touch.
Include blank rows before and after each category to give the appearance of
gaps between categories.
You will need to play with the category labels so the text appears in the
middle of each cluster of stacks.

And thanks for you kind words

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy, thanks much. As you've done so in the past, you're a fountain of
knowledge.

Have structure to where I have my data showing as two separate stacks,
with
one being one value, and the other being two values. Only issue is the
examples get me to the point where I have separated stacks. Any way of
moving each set of two stacks closer to one another? In other words, I
want
each two stacks to be touching, and then a gap, and then the next stack.
The
category labeling issue which I run into using the MS example (the fact
that
the labels show up on every other stack) I can solve by simply doing text
boxes between the two stacks, and taking out tick marks on the axis. But
I
need to have each two stacks come together, so that they are clearly
showing
as being from the same category. I have '07, and see some overlapping and
other parameters, but this moves each stacked section away from the one
below
it. What I want to do is affect the stacks as whole stacks, with relation
to
the next stack.

Any ideas? I'm almost there, and excited I may actually have this happen.

 

[Guest]

multiple pie charts in one overall chart? Just need two pie charts, but to
appear in one overall chart (for pasting purposes, need as one chart, with
one title)?

Thanks again for any guidance.

 

[Andy Pope]

pie charts???? where did that come from?

If you want email me, off newsgroup, you current workbook.

Cheers
Andy