Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination side by side and stacked
am trying in '07 to get 3 series to be side by side columns and 3 others to
be side by side with the first three, but stacked themselves. In other words, 3 of them are large and important, and 3 are getting drowned out in the scaling. This on top of the fact that the width, per period, for all 6 to be side by side, is excessive and makes the graph difficult. So I want to put 3 on top of each other to show the aggregate effect (with divisions, not as one total), and the larger three as single columns themselves (to make sure the trend of each is seen on its own. As I try to change the chart type for just one of the series, it converts the whole graph one way or another (either to all stacked, or all side by side). Any suggestions. Thx. -- Boris |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination side by side and stacked
Try one of these examples:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "BorisS" wrote in message ... am trying in '07 to get 3 series to be side by side columns and 3 others to be side by side with the first three, but stacked themselves. In other words, 3 of them are large and important, and 3 are getting drowned out in the scaling. This on top of the fact that the width, per period, for all 6 to be side by side, is excessive and makes the graph difficult. So I want to put 3 on top of each other to show the aggregate effect (with divisions, not as one total), and the larger three as single columns themselves (to make sure the trend of each is seen on its own. As I try to change the chart type for just one of the series, it converts the whole graph one way or another (either to all stacked, or all side by side). Any suggestions. Thx. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
How do I create stacked columns in xcel rather than side-by-side | 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 |