Stacked Bar and Line on Same Graph
 

Hi

Is it possible to produce, on a single graph, a stacked bar chart and a line
chart with left vertcal axis showing bar scale and right vertical axis
showing line scale.

.... heres hoping ...

John

Stacked Bar and Line on Same Graph
 

Hi,

Assuming you mean column (vertical) rather than bar (horizontal).
Create the stacked column chart based on all the series.
Select series you want as line and via the right-click context menu
change the chart type to line. Then format the line to use the second
axis via the format dialog - scale tab.

If you really did mean bars then the line chart needs to be a xy-scatter.

Cheers
Andy

JohnAmcorF wrote:
Hi

Is it possible to produce, on a single graph, a stacked bar chart and a line
chart with left vertcal axis showing bar scale and right vertical axis
showing line scale.

... heres hoping ...

John

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Stacked Bar and Line on Same Graph
 

Hi Andy
Many thanks for the quick response - this is just what I wanted

John

"Andy Pope" wrote:

Hi,

Assuming you mean column (vertical) rather than bar (horizontal).
Create the stacked column chart based on all the series.
Select series you want as line and via the right-click context menu
change the chart type to line. Then format the line to use the second
axis via the format dialog - scale tab.

If you really did mean bars then the line chart needs to be a xy-scatter.

Cheers
Andy

JohnAmcorF wrote:
Hi

Is it possible to produce, on a single graph, a stacked bar chart and a line
chart with left vertcal axis showing bar scale and right vertical axis
showing line scale.

... heres hoping ...

John

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info