Reverse if negative in 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
Cheers again Andy, finger trouble I'm afraid!

Andy Pope said:
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
Click to expand...
 
Back
Top