Try the links that Andy posted. Or try this:

http://peltiertech.com/WordPress/200...a-target-line/

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


"hawaiiham2000" wrote in message
...
So I would just put a column of data next to my data series and use
autofill
to copy the same number down for the goal?

But how could I create a horizontal line representing a goal or target
that
would go across on a bar chart besides just manual drawing a line?


"David Biddulph" wrote:

Yes. On your worksheet, produce a data series that represents the line
you
want (in the simplest case Xmin Ymin as one point and Xmax Ymax as a
second
point), then add that series as an an extra series on your chart.
--
David Biddulph

"hawaiiham2000" wrote in
message
...
Is there a simple way to add a "goal line" or "target" line to a chart?
I've
looked at the previous posts and can't seem to figure it out. Thanks!