Jon Peltier has instructions for adding a line to a chart:

http://www.peltiertech.com/Excel/Cha...s.html#AddLine


Pat Jennings wrote:
How is a target line, say 98%, included in a bar chart? Some of the bar
data is less than the target, while others have exceeded.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html