Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
My application requires a stacked colunm chart with series lines combined
with a minimum of three (3) data series represented as lines. Using the combined column-line chart I loose both the column "stack" and series lines between column elements. Any help adding Lines for three data series to and existing stacked column chart will be most appreciated. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The built-in custom types have limited usefulness. Here's how to make your
own combination charts. Plot all data as stacked columns. Double click a column and on the Options tab, select Series Lines. Select a series you want changed to a line, choose Chart Type from the Chart menu, and choose the line style you want. Repeat for another series, or press the F4 key. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "ancillaries" wrote in message ... My application requires a stacked colunm chart with series lines combined with a minimum of three (3) data series represented as lines. Using the combined column-line chart I loose both the column "stack" and series lines between column elements. Any help adding Lines for three data series to and existing stacked column chart will be most appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stacked chart with line | Charts and Charting in Excel | |||
Combining stack column chart and non stacked | Charts and Charting in Excel | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How do i add a line graph onto a stacked column chart using data | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel |