Thank you Andy.

I am almost there. I am having a difficult time finding the "uncheck values
cross between categorys" section in the the formatting windows. I'm using
Excel 2003, would it be called something different?

Currently my spreadsheet shows the bars (performance) and I have the line
representing their goal, however, it does not go from edge to edge. It
currently goes from the first performance to the last performance.

Can you help?

"Andy Pope" wrote:

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