Layering Chart Types

J

Jeff

I would like to layer a line graph on a second y axis on top of a "stacked
column" graph with 3 data series in it. Anyone know how to do this?
 
L

Luke M

Create a stacked column chart with all 4 series in it. Then, select the
series you want to become a line. Go to Chart, Chart type, and pick a line
series. Then, again selecting the same series, right-click, format, axis,
move to secondary axis
 
J

Jeff

When i go to chart type, and pick 'line', it changes all of the other series'
to lines also. When i try changing it to line-column, or column-line, it
un-stacks the columns.
 
L

Luke M

Make sure you're only selecting the one series. You also have to use the Menu
bar to change Chart type, don't just simply right-click.
 

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
Move Data Series Manually 4
Creating a clustered column chart 1
How do i create a user defined chart in Powerpoint or excel? 1
Chart with VB programming? 2
Combo chart format- what is the best way to achieve this design? 1
stacked area chart with varying fills 1
Combining a 2-D column graph and a 2-D line graph on the same char 3

Top