Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining stacked with side-by-side bar
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 -- Boris |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining stacked with side-by-side bar
Hi,
The examples are for columns but should be adaptable for bars. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BorisS" wrote in message ... 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 -- Boris |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining stacked with side-by-side bar
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. -- Boris "Andy Pope" wrote: Hi, The examples are for columns but should be adaptable for bars. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BorisS" wrote in message ... 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 -- Boris |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining stacked with side-by-side bar
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 "BorisS" wrote in message ... 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. -- Boris "Andy Pope" wrote: Hi, The examples are for columns but should be adaptable for bars. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BorisS" wrote in message ... 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 -- Boris |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining stacked with side-by-side bar
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. -- Boris "Andy Pope" wrote: 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 "BorisS" wrote in message ... 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. -- Boris "Andy Pope" wrote: Hi, The examples are for columns but should be adaptable for bars. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BorisS" wrote in message ... 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 -- Boris |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining stacked with side-by-side bar
pie charts???? where did that come from?
If you want email me, off newsgroup, you current workbook. Cheers Andy BorisS wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do a side by side stacked bar graph using 4 data series? | Charts and Charting in Excel | |||
Graphing-Two stacked columns side-by-side per year | Charts and Charting in Excel | |||
How do I make a stacked column chart with side-by-side comparison. | Charts and Charting in Excel | |||
Data markers in a stacked chart will not sit side by side by month | Charts and Charting in Excel | |||
Data markers in a stacked chart will not sit side by side by month | Charts and Charting in Excel |