How can I add a new axis as a line chart toa stacked bar chart

[Susan]

I have 5 months of data as a stacked bart chart - the Y-axis is the count of
orders that missed target due to a particular reason. So for month 1, there
are 100 misses across 5 categories; in month 2, there are 80 misses across
the same 5 categories etc. I want to add a new axis that shows the total
number ordered - missed or not. This total is always much higher so I'd like
to add it as a separate axis as a LINE that will show on top of the stacked
bar for each month. How can I do this?

 

[Jon Peltier]

Add the data to the chart, either by copying the data, selecting the chart,
and using Paste Special, or by opening the Source Data dialog, adding a
series, and defining the ranges.

Then select the added series, and use Chart menu > Chart Type to change to a
line style.

- Jon