Specify colors for certain column values in Bubble Chart in colorAxis

[down.with.the.bass]

I'm trying to set a constant color when a specific column, say column 3, has a certain value. For instance if column 4 has the value = "D", then color for that bubble should be "blue". Is there a way I can set these conditions?

[asgallant]

You would assign colors to series with the series.<series index>.color option.  I'm not sure how the API maps string values to data series indices here, though.  My advice would be to sort the DataTable so that the string values are always in the same order, and then figure out which string value belongs to which data series, and set colors appropriately.

[asgallant]

Oh, I forgot to mention: bubble color is always determined by the value in column 3 (if present).  You cannot use any other column to determine color.