8 Replies Latest reply: Jul 1, 2015 2:10 AM by Manish Kachhia

# How to convert stacked bar chart in multicolor?

Hello Community,

I have one application in that i have created one stacked bar chart.I have used two expressions.And i am showing top                             five.It is showing the top 5 bars.

• ###### Re: How to convert stacked bar chart in multicolor?

Hi,

Use multy color under colors tab with persitence and chart style as grouped.

*Posting sample data or desired outcome screenshot will help community to address your issue

Thanks.

• ###### Re: How to convert stacked bar chart in multicolor?

Hii

But in stack bar chart multicolor option is disabled.We cant do multicolor in stack i tried.

Thanks

• ###### Re: How to convert stacked bar chart in multicolor?

Can you share sample data!

Thanks

• ###### Re: How to convert stacked bar chart in multicolor?

How many preoperties are there in your dimensions!

depends on that you can color the bars in expression tab.

• ###### Re: How to convert stacked bar chart in multicolor?

Amarnath,

Find this thread stacked bar chart - define colours

• ###### Re: How to convert stacked bar chart in multicolor?

Hi Amarnath,

U can use Color tab. ther u will have option.

Ramya.

• ###### Re: How to convert stacked bar chart in multicolor?

Go to Expression

Click on + sign of Expression

Write Below Expression under BackGround Color

IF(RANK(TOTAL SUM(TotalSales))=1, Green(),

IF(RANK(TOTAL SUM(TotalSales))=2, Blue(),

IF(RANK(TOTAL SUM(TotalSales))=3, QlikTechGray(),

IF(RANK(TOTAL SUM(TotalSales))=4, Black(),

IF(RANK(TOTAL SUM(TotalSales))=5, RGB(40,50,50))))))

=====================================

SUM(TotalSales) is Expression which is for my first Expression.

You can swap it with expression you used in your application.

Also, similar approach need to be done in second expression. Use colors as per your choice..