Add line series to stacked bar chart

T

TomB

I want to add a line on top of a stacked bar chart. Is there a straight
forward way to do this?
 
J

Jon Peltier

I presume you mean a column chart (vertical bars). Copy the data, select the
chart, use Edit menu > Paste Special to add the data as a new series. This
adds the series as another bar on the stack. Select the new series, go to
Chart menu > Chart Type, and choose a line type. Format to suit.

- Jon
 

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 Line Chart 3
Stacked bar chart with totals - Excel 2003 2
Adding a Second and Third Line to an Existing Stacked Bar/Line Cha 3
Stacked bar, bar and line graph 1
Stacked column chart narrow bars wanted 5
stacked bar, and column, two axes 2
Total of Stacked Column Chart 1
Stacked bar Chart in Excel 2007 1

Top