Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination chart: 3 stacked columns + 1 line
Wanted to know if anyone has done this successfully:
3 stacked columns with a separte data series as a line. I am finding that you can do a combination with: 2 stacked columns but not 3. BTW: read 6/5/06 posting with Andy Pope response but did not address 3 stacked columns in the thread "Subject: line-column combination chart, with stacked ... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination chart: 3 stacked columns + 1 line
Forget all about the built in custom chart types. It's very easy to make
your own custom combinations that do what you want. Make the chart using all series as stacked columns. Select the series you want to change to a line, and use Chart Type from the Chart menu to change its type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Lancecar" wrote in message ... Wanted to know if anyone has done this successfully: 3 stacked columns with a separte data series as a line. I am finding that you can do a combination with: 2 stacked columns but not 3. BTW: read 6/5/06 posting with Andy Pope response but did not address 3 stacked columns in the thread "Subject: line-column combination chart, with stacked ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a stacked bar, line combination chart | Charts and Charting in Excel | |||
Stacked chart with line | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Custom Chart: Stacked Bar & Line | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |