| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Reverse if negative in 2007
In a previous version of excel, our users could create a chart from some
negative/positive data and format it using the above option so neg was red, pos was blue! Doesn't appear to be the same ability in 2007? Anyone? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Reverse if negative in 2007
Hi,
This was discussed in an early thread, with the title 'plot 0 as green and < 0 as red' You can, with VBA code or my add-in, get the Invert If Negative to work but you have to retain a fill pattern. As soon as you set the fill to Solid the second color is lost. http://www.andypope.info/charts/patternfills.htm The other approach is to use 2 data series based on original data. 1 for positive 1 for negative values. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "scoz" wrote in message ... In a previous version of excel, our users could create a chart from some negative/positive data and format it using the above option so neg was red, pos was blue! Doesn't appear to be the same ability in 2007? Anyone? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Reverse if negative in 2007
Cheers Andy. I got the download but I can't get any response from the new
button!? Scoz "Andy Pope" wrote: Hi, This was discussed in an early thread, with the title 'plot 0 as green and < 0 as red' You can, with VBA code or my add-in, get the Invert If Negative to work but you have to retain a fill pattern. As soon as you set the fill to Solid the second color is lost. http://www.andypope.info/charts/patternfills.htm The other approach is to use 2 data series based on original data. 1 for positive 1 for negative values. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "scoz" wrote in message ... In a previous version of excel, our users could create a chart from some negative/positive data and format it using the above option so neg was red, pos was blue! Doesn't appear to be the same ability in 2007? Anyone? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Reverse if negative in 2007
Hi,
Check your Trust setting and make sure Disable all application add-ins is not ticked. OfficeButton Excel Options Trust Center Trust Center Settings Addins Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "scoz" wrote in message ... Cheers Andy. I got the download but I can't get any response from the new button!? Scoz "Andy Pope" wrote: Hi, This was discussed in an early thread, with the title 'plot 0 as green and < 0 as red' You can, with VBA code or my add-in, get the Invert If Negative to work but you have to retain a fill pattern. As soon as you set the fill to Solid the second color is lost. http://www.andypope.info/charts/patternfills.htm The other approach is to use 2 data series based on original data. 1 for positive 1 for negative values. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "scoz" wrote in message ... In a previous version of excel, our users could create a chart from some negative/positive data and format it using the above option so neg was red, pos was blue! Doesn't appear to be the same ability in 2007? Anyone? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Reverse if negative in 2007
Cheers again Andy, finger trouble I'm afraid!
"Andy Pope" wrote: Hi, Check your Trust setting and make sure Disable all application add-ins is not ticked. OfficeButton Excel Options Trust Center Trust Center Settings Addins Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "scoz" wrote in message ... Cheers Andy. I got the download but I can't get any response from the new button!? Scoz "Andy Pope" wrote: Hi, This was discussed in an early thread, with the title 'plot 0 as green and < 0 as red' You can, with VBA code or my add-in, get the Invert If Negative to work but you have to retain a fill pattern. As soon as you set the fill to Solid the second color is lost. http://www.andypope.info/charts/patternfills.htm The other approach is to use 2 data series based on original data. 1 for positive 1 for negative values. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "scoz" wrote in message ... In a previous version of excel, our users could create a chart from some negative/positive data and format it using the above option so neg was red, pos was blue! Doesn't appear to be the same ability in 2007? Anyone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reverse value | Excel Worksheet Functions | |||
| reverse value | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Reverse Sum | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Hybrid Mode
