Multicolor in combined Graphs

[#1]

Hello!

I need to create a combined graphic, with bars and a line graphic.

Can I activate multicolor option in the bars graphic?

Thanks.

[Gysbert_Wassenaar]

Yes, add the dimensions and expressions. And choose how the expressions should be displayed (bar and/or line)

[#3]

Thanks for the answer, but the problem is that when I choose that one expresion is the bars and the other is the line graphic, the multicolor option is desactivates and all my bars turn into green, and I need that each bar had its own color.

[Gysbert_Wassenaar]

Ah, yeah. The option on the colors tab is not available. But if you click on the + in front of the expression on the Expressions tab you can click on Background Color and change the expression to calculate a different background color for every bar.

[#5]

OK, I´ve found it, but I don´t know how to change the color for each bar........

[Gysbert_Wassenaar · Accepted solution]

for random colors: =rgb(floor(255*Rand()),floor(255*Rand()),floor(255*Rand()))

or you could use an if then statement

=if(Product='foo', Red(),if(Product='bar',Blue(),Green()))

[#7]

Thanks a lot, finally I´ve made it