Stacked Bar and Line on Same Graph

G

Guest

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stacked column graph adjacent to a regular column graph 0
Combination Stacked Bar and Line Graph 1
Combo chart format- what is the best way to achieve this design? 1
Superimposing Charts 2
Dynamically Scale Gantt Chart Time Scale 2
Stacked Bar - 2 Axes 1
3D stacked bar and line chart on same graph 2
Creating a clustered column chart 1

Top