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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan - 13 May 2008 18:19 GMT

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?

Reply to this Message

Jon Peltier - 13 May 2008 19:26 GMT

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
_______

>I have 5 months of data as a stacked bart chart - the Y-axis is the count
>of
[quoted text clipped - 7 lines]
> stacked
> bar for each month. How can I do this?

Reply to this Message