how to add overlay line chart to stacked bar

M

Molly M

I'm using Microsoft Excel for Mac OS X. I'm trying to create an overlay
chart with a stacked bar with a line over it. I can only get it to do a
regular bar chart with a line over it. What am I doing wrong? Thanks!
 
D

Debra Dalgleish

I no longer have a Mac, but you can try the following:

1. Create a stacked column chart from all the data
2. Select the series that you want as a line
3. Choose Chart>Chart Type, and choose the Line
chart type, and one of the subtypes
4. Click OK
 

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

Overlay line graph points on bar graph 1
sideways stacked bar charts with line series on the same axis 0
Stacked Bar Chart 1
Overlapping floating column charts? 1
How to make scroll bar permanently visible, Word 365 0
Bar Chart with Data Elements 1
Stacked Line Chart 3
3D stacked bar and line chart on same graph 2

Top