5 Replies Latest reply on May 17, 2012 9:05 AM by Chris.Grant

# Symbol color manipulation

The color editing in 7 is wonderful.  However, I've hit something I don't know how to do.

I have a scatter plot of points whose values range from 1 to 10.  I want the 1's to be red.  I want 2-10 to be some other color, fading in intensity as the number gets higher.

1.  Can I manually change the color of just one or two individual symbols?

2.  Can I create a custom color scheme that "converges" instead of diverges?  (i.e. in converging the center of the spectrum would be black or very dark, as opposed to "diverging" where the center of the spectrum is faded i.e. pale.

I suspect these are just outside Tableau's reach, and I'll end up doing a manual overlay in an image-editing program, but could use suggestions please!

• ###### 1. Re: Symbol color manipulation

I couldn't find a way to do a diverging color scheme. It's simple enough to set 1 to red by messing with the center value of the gradient:

To get the diverging effect you want, you could create a calculation that makes the calculation result smaller as the value grows, and combine this with the effect above:

1 of 1 people found this helpful
• ###### 2. Re: Symbol color manipulation

Alex, thanks!

I already am doing the midpoint thing, and your recalculation suggestion sounds like it will solve the other half of the problem.

It still would be nice to be able to change individual symbols manually, in case I needed a third color.  I'll look for a place to suggest it.

• ###### 3. Re: Symbol color manipulation

Another way to do this is to separate the values into two measures and then use a dual axis and multiple mark types. Then I can set one to red, and the 2 to 10 as a fading blue line:

if [Value]=1 then [Value] end

and

if [Value]>1 then [Value] end

And you could extend this to another color as well.

• ###### 4. Re: Symbol color manipulation

Just for completeness you can also set a custom sequential palette (http://kb.tableausoftware.com/articles/knowledgebase/creating-custom-color-palettes) with any colors you like including a light outer to dark center:

• ###### 5. Re: Symbol color manipulation

Perfect.  Thank you!