Thread: How to change line chart color based on condition like + and -.
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 to change line chart color based on condition like + and -.
Hi,

This may help
http://www.andypope.info/charts/conditionalline.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"egii" wrote in message
...
I have a line chart that is somtimes negative and somtimes positive. I
would
like the line when negative to be red and when positive to be black or
blue
or green. Is there a conditional format procedure for line charts?

Reply With QuoteReply With Quote