Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Does anyone know a way to create a chart that combines the stacked column
chart with a line or scatter chart. I know there is a combo chart but that will not let me use a stacked column |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Forget the built-in options. It is easy to make your own combination charts
which can be so much more flexible. Start by making the chart using the predominant series type, in your case, stacked column. Select a series which you want to change to a line type, go to Chart menu, Chart Type, and select the line type you want. Repeat as necessary. To put any series onto a secondary axis, double click on it, and go to the Axis tab. Combination Charts: http://peltiertech.com/Excel/Charts/ComboCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Taebaek" wrote in message ... Does anyone know a way to create a chart that combines the stacked column chart with a line or scatter chart. I know there is a combo chart but that will not let me use a stacked column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Charts | Charts and Charting in Excel | |||
Creating Multiple Charts from One PivotTable | Charts and Charting in Excel | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
Can I import a new colour into the options for creating charts? | Charts and Charting in Excel | |||
Creating custom colours in Excel 2002 | Excel Discussion (Misc queries) |