Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to have a Line - Stacked Column Chart?
I am trying to create a chart with a stacked column plotted on the primary
axis and a line on the secondary axis. I have seen the custom chart type of a Line - Column chart, but I want to stack the columns. Is this possible? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to have a Line - Stacked Column Chart?
Hi,
Ignore the builtin custom types and just create your own. Start with a stacked column chart of all your data and then double click the series that you want on the secondary axis. Change the setting to secondary via the Axis tab of the format dialog. Then right click the series and change the chart type to Line. Cheers Andy GSchool wrote: I am trying to create a chart with a stacked column plotted on the primary axis and a line on the secondary axis. I have seen the custom chart type of a Line - Column chart, but I want to stack the columns. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to have a Line - Stacked Column Chart?
Thank you very much!
"Andy Pope" wrote: Hi, Ignore the builtin custom types and just create your own. Start with a stacked column chart of all your data and then double click the series that you want on the secondary axis. Change the setting to secondary via the Axis tab of the format dialog. Then right click the series and change the chart type to Line. Cheers Andy GSchool wrote: I am trying to create a chart with a stacked column plotted on the primary axis and a line on the secondary axis. I have seen the custom chart type of a Line - Column chart, but I want to stack the columns. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to have a Line - Stacked Column Chart?
Thank for this information. It was the answer to the problem I'd been
looking for! -- Sharon "Andy Pope" wrote: Hi, Ignore the builtin custom types and just create your own. Start with a stacked column chart of all your data and then double click the series that you want on the secondary axis. Change the setting to secondary via the Axis tab of the format dialog. Then right click the series and change the chart type to Line. Cheers Andy GSchool wrote: I am trying to create a chart with a stacked column plotted on the primary axis and a line on the secondary axis. I have seen the custom chart type of a Line - Column chart, but I want to stack the columns. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I limit my chart | 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 to create combination stacked area and line chart? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |