View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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?