| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Positive and negative graph
Hi,
How can I do so that my columns above zero be green and the ones below zero be red. Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Positive and negative graph
Hi,
In versions prior to 2007 you are use invert if negative. http://www.andypope.info/charts/Invertneg.htm http://peltiertech.com/Excel/ChartsH...fNegative.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Construk" wrote in message ... Hi, How can I do so that my columns above zero be green and the ones below zero be red. Thanks |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Positive and negative graph
Thanks !
"Andy Pope" wrote: Hi, In versions prior to 2007 you are use invert if negative. http://www.andypope.info/charts/Invertneg.htm http://peltiertech.com/Excel/ChartsH...fNegative.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Construk" wrote in message ... Hi, How can I do so that my columns above zero be green and the ones below zero be red. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| showing negative values as positive in a bar graph | Excel Discussion (Misc queries) | |||
| negative and positive sums | Excel Worksheet Functions | |||
| Some Positive, Some Negative | Excel Worksheet Functions | |||
| IF positive/If negative???? | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Linear Mode
