How do I combine a line and a percentage stacked column chart?

L

Liza

I would like to combine stacked percentage columns on the primary axis with
lines on the secondary.
 
B

Barb Reinhardt

If it were me, I'd create a stacked chart with all of the data. I'd then
double click on the data series for the secondary axis to get FORMAT DATA
SERIES. I'd select the AXIS tab and choose secondary.

'd then right click on the same data series that is to be made into a LINE
chart. You'll see Chart Type as an option. Change the chart type for the
series to LINE. You may need to adjust your scaling for the 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

column charts with set set of data 0
sideways stacked bar charts with line series on the same axis 0
How can I combine a stacked column chart and line chart? 1
Adding line chart w/ 2nd axis to stacked bar chart 1
Chart data scrunches to left when adding X axis date series 0
Sorting a stacked column 0
Combo Stacked column/column/line 1
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0

Top