How do I change the color of ONE line on the y-axis in a chart?
 

I'm working with a column graph. I want the line that represents 90% to
serve as a benchmark and be a different color than the other lines in the
y-axis. Meaning all other lines are black, theline at 90% is red. How do I
change the color of just this line without adding a drawing object?

How do I change the color of ONE line on the y-axis in a chart?
 

Hi,

These sites have instructions for adding datum lines,
http://peltiertech.com/Excel/Charts/...orzErrBar.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Merna" wrote in message
...
I'm working with a column graph. I want the line that represents 90% to
serve as a benchmark and be a different color than the other lines in the
y-axis. Meaning all other lines are black, theline at 90% is red. How do
I
change the color of just this line without adding a drawing object?