How do I create a stacked column/line chart combination?

I am trying to format a line/stacked column combination chart. I want to
show the delay on each of several machines as a stacked column, and then I
want to show a line representing the goal for the down time, the goal being a
set value, so the line will be straight across.

Simples way is to plot all the data, stacked columns plus one series for the
horizontal line, as a stacked column chart. Select the series that should be
the line, choose Chart Type on the Chart menu, and pick out a line chart
style.

A bit more involved is to add a line using an XY series of two points, or an
XY series of one point with an error bar:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Cori" <Cori@discussions.microsoft.com> wrote in message
news:A63978A5-8C86-4DAA-8B85-3B17B277B502@microsoft.com...
>I am trying to format a line/stacked column combination chart. I want to
> show the delay on each of several machines as a stacked column, and then I
> want to show a line representing the goal for the down time, the goal
> being a
> set value, so the line will be straight across.
>

Maybe my problem lies in how I am plotting my data. I can make a stacked
column, but I guess I'm not sure where I need to be putting my data that I
want displayed as a line. The line will be straight across, it is simply a
down time report that shows the amount of down time on different machines,
which is what I want stacked, and then the line would represent the allowable
maximum goal for the down time, which is one set value. So I am showing each
machine's time stacked, compared to the goal.

"Jon Peltier" wrote:

> Simples way is to plot all the data, stacked columns plus one series for the
> horizontal line, as a stacked column chart. Select the series that should be
> the line, choose Chart Type on the Chart menu, and pick out a line chart
> style.
>
> A bit more involved is to add a line using an XY series of two points, or an
> XY series of one point with an error bar:
>
> http://peltiertech.com/Excel/Charts/AddLine.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Cori" <Cori@discussions.microsoft.com> wrote in message
> news:A63978A5-8C86-4DAA-8B85-3B17B277B502@microsoft.com...
> >I am trying to format a line/stacked column combination chart. I want to
> > show the delay on each of several machines as a stacked column, and then I
> > want to show a line representing the goal for the down time, the goal
> > being a
> > set value, so the line will be straight across.
> >
>
>
>

If your data can make a stacked column chart with the line's data included
at first as another stack in the column, then it's arranged appropriately,
and you only have to change the series type as I've described. If the data
for the line is not connected in the sheet with the other data, you can add
it to the chart, either using Copy/Paste Special or Chart menu > Source Data
> Series tab > Add button.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Cori" <Cori@discussions.microsoft.com> wrote in message
news:85AE7ED8-66BE-43E3-B789-16F86EE9347E@microsoft.com...
> Maybe my problem lies in how I am plotting my data. I can make a stacked
> column, but I guess I'm not sure where I need to be putting my data that I
> want displayed as a line. The line will be straight across, it is simply
> a
> down time report that shows the amount of down time on different machines,
> which is what I want stacked, and then the line would represent the
> allowable
> maximum goal for the down time, which is one set value. So I am showing
> each
> machine's time stacked, compared to the goal.
>
> "Jon Peltier" wrote:
>
>> Simples way is to plot all the data, stacked columns plus one series for
>> the
>> horizontal line, as a stacked column chart. Select the series that should
>> be
>> the line, choose Chart Type on the Chart menu, and pick out a line chart
>> style.
>>
>> A bit more involved is to add a line using an XY series of two points, or
>> an
>> XY series of one point with an error bar:
>>
>> http://peltiertech.com/Excel/Charts/AddLine.html
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "Cori" <Cori@discussions.microsoft.com> wrote in message
>> news:A63978A5-8C86-4DAA-8B85-3B17B277B502@microsoft.com...
>> >I am trying to format a line/stacked column combination chart. I want
>> >to
>> > show the delay on each of several machines as a stacked column, and
>> > then I
>> > want to show a line representing the goal for the down time, the goal
>> > being a
>> > set value, so the line will be straight across.
>> >
>>
>>
>>