9 Replies Latest reply: Jun 23, 2017 8:28 AM by Leandro Duarte

# Percentages in axes of mekko chart

Hi guys,

Please take a look at the qvw attached.

There is a Mekko chart.

Does anyone knows how to:

.- Show Axis values as percentages ==> 70% instead of 0.7
.- Show Expresion values into expresison background, i.e. 8991 into green color
.- Show expression also as %, i.e. 8991 - 74%

Aldo.

• ###### Re: Percentages in axes of mekko chart

Set the number format on "Numbers" tab using "Show in Percent(%)" option (for all 3 expressions).

On the presentation tab select "Plot Values Inside  Segments"

Change all expressions to be normalized:

Sum([Ex Stock]) into Sum([Ex Stock])/(Sum(Late)+Sum([On Time])+Sum([Ex Stock]))

and same for the others.

• ###### Re: Percentages in axes of mekko chart

Sorry, I thought it was the solution I was looking for, but actually setting all exp. to %, makes all bars to have the same width (or looks like) and I need to bolt the different volumes over YM.

Aldo.

Message was edited by: Aldo Liaks

• ###### Percentages in axes of mekko chart

Hey Hi Aldo,

Just go to Properties->Number ,then select your expression and in number select format check Number ->check Show in% at bottom.

thax

• ###### Re: Percentages in axes of mekko chart

Hi Aldo, did you find a solution for this? I see the same problem... thanks in advance Leandro

• ###### Re: Re: Percentages in axes of mekko chart

Dear Leandro Duarte,

Kindly find the attachment.

Thanks,

Mukram.

• ###### Re: Percentages in axes of mekko chart

Hi Mukran, the idea is to have the values in the chart in absolute value, but only the Y axis to be in %. it is already today 0.5 something.. but in the end the best display for this is %

thanks Leandro

• ###### Re: Percentages in axes of mekko chart

Hello Leandro,

have you been lucky with finding a solution for this challenge? If so can you please share your insights here?

Thank's and bests

Peter

• ###### Re: Percentages in axes of mekko chart

not really, I need to look this case again

• ###### Re: Percentages in axes of mekko chart

Hi Aldo, Peter,

I've figured out a solution for this problem.

Clue is

- Use a one-dimension, multi-expression Mekko (as you did, but that was not my start)

- Add an extra 0 expression, with number formatting percentage

- Make from your values Duals, with as text representation the percentage of the vertical bar, and as number the absolute value

See attachment!