Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up a chart in Excel with lines and stacked bars?
I am trying to set up a chart that will have stacked bars overlayed with a
line graph. Is this possible to do? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up a chart in Excel with lines and stacked bars?
First make the chart as a stacked columns chart.
IN the chart, right click on the data series to be a line; select Chart Type and specify Line best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jan" wrote in message ... I am trying to set up a chart that will have stacked bars overlayed with a line graph. Is this possible to do? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up a chart in Excel with lines and stacked bars?
Hi,
Yes it is possible if you are not using the 3d styles. Create the stacked column chart based on all your data. Then select the series you want to plot as a line. Use the menu Chart Chart Type... to select the required line chart style. Cheers Andy Jan wrote: I am trying to set up a chart that will have stacked bars overlayed with a line graph. Is this possible to do? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add line to a stacked area chart already created | Charts and Charting in Excel | |||
Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
stacked column chart across multiple columns | Charts and Charting in Excel | |||
plot roadmap chart in excel | Charts and Charting in Excel | |||
Excel Connector Lines | Charts and Charting in Excel |