Stacked column with line chart

[chameleon43341]

I have a chart which shows units gained above the axis, units disposed
of in a column under the axis and net units as a line. I have trend
lines on 3 months average for both the units gained and disposed of. I
am now being asked to show units massed moved under the line stacked on
the diposal units. How do I accomplish this? I looked for a custom
graph in Excel and cannot find one to do what I want.
Can anyone help me?

 

[Jon Peltier]

Draw your own custom chart. For an existing chart, right click on it,
select Source Data from the pop up menu, and click on the Series tab.
Click the Add button, and select the range containing its data. Then
right click on the new series, which must be stacked somewhere you don't
want it, choose Chart Type from the pop up menu, and choose a line style
for this series.

For a new chart, select all the data at once and make your chart, then
change the one series to a line style as described above, then add
whatever trendlines you need.

- Jon