Hi,

The following pages have examples of how to add lines.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

mtwelsh72 wrote:
I have a bar graph that graphs percentages to goal, I would like to display a
line within the bar graph that represents the goal. If possible, I would
then like to have the background of the graph below the goal line to be red,
and above the goal line to be another color. Can this be done?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info