Hi,

The concept is the same in xl2007.
http://www.andypope.info/charts/averageline.htm
http://peltiertech.com/Excel/Charts/AddLine.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"wcurtis" wrote in message
...
How do I add an area to a 2007 chart that shows the goals we are trying to
acheive?
I have a column chart with twelve months and need to have a horizontal
shaded bar that shows the goal are we are trying to stay in.

Thanks