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?

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?

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?

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?

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?