Reverse if negative in 2007

[scoz]

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?

 

[Andy Pope]

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

 

[scoz]

Cheers Andy. I got the download but I can't get any response from the new
button!?
Scoz

 

[Andy Pope]

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

 

[scoz]

Cheers again Andy, finger trouble I'm afraid!

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