Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default How to change line chart color based on condition like + and -.

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change a chart line color if it doesn't allow the option Bux Excel Discussion (Misc queries) 1 January 21st 09 06:17 AM
Change Line color based on 2 different cells lawdoggy Excel Discussion (Misc queries) 4 October 23rd 06 10:14 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
Change row color based on condition of celss B G Excel Worksheet Functions 3 June 28th 06 08:56 PM
Color Change in chart based of condition KRT Charts and Charting in Excel 1 July 1st 05 12:51 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"