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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Susan" wrote in message
...
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?