Hichert Partner Logo

English (United Kingdom)

Community > Foren

Willkommen, Gast
Bitte anmelden oder registrieren.    Passwort vergessen?
Zum Ende gehen antworten 
How to build Red-green graph with "Invert if negative"
How to build Red-green graph with "Invert if negative" vor 4 Jahren, 8 Monaten  
In FAQ 024 it is said that the "Invert if negative" trick does not work in Excel 2007. This is not true, there is a solution.

It is true that the trick does not work with Pattern fill. Even if you download the pattern fill UI add-in, it will not work. BUT you don't need this, because it can be done with Gradient fill in the following way:

  1. Choose Format Data Series and set Fill ta Gradient fill

  2. Set the Invert if negative check box

  3. Set gradient Stop 1 to Stop position 1% and choose green color

  4. Set gradient Stop 2 to Stop position 1% and choose red color

  5. Set gradient Stop 3 to Stop position 99% and choose green color

  6. Add gradient Stop 4 and set it to Stop position 99% and choose red color


That's it, enjoy

Best regards to the community!

Andrej,
www.istudio.si
 
  Kein öffentlicher Schreibzugriff erlaubt, bitte erst registrieren!