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

sideways stacked bar charts with line series on the same axis 0
Stacked Bar Chart 1
Stacked Line Chart 3
Unreadable text when viewing organization chart in Web version of Visio 365 0
Export BPMN Visio Chart to Excel 0
Doughnut Chart linked with the slicer in the pivot table 0
Stacked bar chart with totals - Excel 2003 2
3D stacked bar and line chart on same graph 2

Top