Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a chart line color if it doesn't allow the option | Excel Discussion (Misc queries) | |||
Change Line color based on 2 different cells | Excel Discussion (Misc queries) | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Change row color based on condition of celss | Excel Worksheet Functions | |||
Color Change in chart based of condition | Charts and Charting in Excel |