how to use the same colours

[#1]

I have a list of clients, their location (X,Y coordinate) and their market segment. I have plotted these clients over a map in a scatter plot diagram. So far so good.

Now I want to assign a specific colour to a market segment, so if I select the market segment view I see the same clients, but then coloured according the market.

I have really no Idea how to solve it. an example of my issue is in the appendix.

Who can give me the clue?

regards

perry

[rustyfishbones · Accepted solution]

How many segments do you have?

If it's not too many you could create an IF statement

Add it here

IF(MarketSeg = 1, RGB(0,255,0),

     IF(MarketSeg = 2, RGB(255,200,200),

          IF(MarketSeg = 3, RGB(0,100,50),

          RED())))

[#3]

Thanks a lot! I only have a limited amount of segments and it works perfectly.

thanks for your help.

perry

[rustyfishbones]

no problem, glad it helped

[#5]

Yeah the IF condition was the best and easy way for it. I too had tried it and it was successful for me too.

water damage pompano beach