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

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?

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

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?