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

Use text descriptors as Y axis units 1
Create a chart from a table in word thats dynamic 0
Getting the graph style I want 4
Dynamic series in rows 1
Plotting Graph with dynamic table 3
Make Y-axis values correspond to x- axis value 1
sideways stacked bar charts with line series on the same axis 0
Move Data Series Manually 4

Top