Stacked Bar - 2 Axes

N

nerokyc

How can I have a stacked bar using one axes combined with a line graph as a
second axis?
 
S

ShaneDevenshire

Hi,

Plot all of your series as a stacked bar chart. Then select the one series
you want as a line chart and choose Chart, Chart Type and pick Line. To run
it along the second Y axis, select the line and choose Format, Selected Data
Series, Axis, Secondary Axis.
 

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

Creating a clustered column chart 1
stacked bar, and column, two axes 2
Stacked chart with line 1
Combination Stacked Bar and Line Graph 1
How do i create a user defined chart in Powerpoint or excel? 1
stacked column graph adjacent to a regular column graph 0
superimposed 3-D stacked area charts 2
Excel How to create a stacked bar graph 0

Top