Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining a stacked column and line chart together
I need to know how I combine a stacked column chart with a line chart (2 or
more lines are required on the chart) with two different y axis values. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combining a stacked column and line chart together
Create a stacked column chart using all of the data. Select a column series
in the stack that you want to change to a line. Go to Chart menu Chart Type, and select a line type. Repeat as needed for other series. Double click on any series you want to move to the secondary axis, and on the Axis tab, select Secondary. Repeat as needed. You should try to keep all of the stacked columns on the same axis, otherwise they will not stack correctly, and stacking differently scaled columns makes no sense. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Abi Dodds" <Abi wrote in message ... I need to know how I combine a stacked column chart with a line chart (2 or more lines are required on the chart) with two different y axis values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to have a Line - Stacked Column Chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
Combination stacked column/line chart | Charts and Charting in Excel | |||
Combining stack column chart and non stacked | Charts and Charting in Excel | |||
Combined line/stacked column chart | Charts and Charting in Excel |