Combo Chart of stacked columns and line

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

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


In article ,
says...
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