Using a formula to set colour

Mar 9, 2010 at 3:18 PM

Hi all,

I want to set the colour based on a particular attribute. I'm able to set the size using an IF function, but I don't know how to set the colour.


Any ideas?

Mar 9, 2010 at 3:47 PM

The easiest way is to use the Autofill Columns feature, which can be found at NodeXL, Visual Properties, Autofill Columns.  You specify the name of a "source column" containing the attribute you want to use to set the Color values, and NodeXL does all the calculations and fills in the Color column for you.

If you would rather use formulas, here is a sample formula that sets the Color column on the Edges worksheet to Red if the corresponding value in the Attribute Column is greater than 2, or to Blue otherwise:

=IF(Edges[[#This Row],[Attribute Column]] > 2, "Red", "Blue")

-- Tony

Mar 10, 2010 at 6:35 AM

Hi Tony,

Thanks - both work well.