Combo Chart of stacked columns and line

A

Antje Crawford

Hello,
is there a custom chart template that will show data as a
combination of stacked columns and line in the same chart.
I have data from two different areas of the company that I
would like to put in the stacked columns (so the data
shows individually but also a total for both areas
together) and I have a goal for this kind of data that I
would like to show as a line graph.
Any suggestions, solutions are greatly appreciated.
TIA.
BR, Antje Crawford
 
T

Tushar Mehta

Plot all the data as a stacked column. Then, on the chart select the
plotted series that you want as a line chart. With it selected, select
Chart | Chart Type... | line chart + desired sub-type.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 

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 Clustered Column? 1
Stacked Bar Chart 1
Clustered-Stacked-Column Combo Chart With Lines 2
How can I combine a stacked column chart and line chart? 1
stacked column chart 4
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Total of Stacked Column Chart 1

Top