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