100% stacked bar chart

[Anonymous]

hi

I have a bit of a problem I need to create a graph that shows data as per below:

                  Europe      Rest of World

Client         100%            0%

Industry       52%             48%

Portfolio       34%             66%

I can create a graph as such without a problem by using Valuelist but when the client has 100% in either Europe of Rest of World part, the rest of the graph (I mean Industry and Portfolio) will not show the part where Client has 0%

the graph will only show this:

                  Europe      Rest of World

Client         100%          

Industry       52%           

Portfolio       34%           

I know this sounds petty but some Clients demand to see the Rest of World % no matter what. I did somehow manage to do this before but for the love of God I cannot remember how I did it and I don't have it saved anywhere.

any ideas?

[sunny_talwar]

Would you be able to share an image of what you have and the expression you are using?

[ychaitanya]

use the expr for Rest of World as 100 - Expression for Europe

Have you tried that ?

[sudhirpkuwar · Accepted solution]

Hi Monika,

Check this

if you can find it helpful....

[Anonymous]

this worked, thanks Sudhir