Mekko chart-Y-axis as a percentage

[Anonymous]

Hi All,

I'm having a problem with a mekko chart I'm working on.

>I have five dimensions as shown in the chart.

>The Y-axis has a scale of 0 to1.0. Is there some way i can convert this to a scale of 0 -100%.?

I tried the static min,max options but its not working.

Thanks again for you help.

Padmashri

[venkatg6759]

Check the screenshot

[Anonymous]

Hi.

Just go to the Number tab of the chart properties and check "Show as percentage" for your expression.

[Anonymous]

Hi Venkatg

Thanks for the reply.If i do this then the values inside the data points also appear as a percentage. I want to them to have calculated values and not % .

[Anonymous]

Hi Bruno,

Thanks. I tried this but this happens.

[venkatg6759]

Your Y axis is the expression .If you are giving relative it reflects the entire expression,

[#7]

Hi there,

Do you mind attaching your sample file.

Thanks

[venkatg6759]

Hi Padmasri,

You can make another chart and overlap something like the screenshot

[Anonymous]

In that case, the only thing I can think of is an ugly solution: configure the any way you like at the Number Tab and create a fake y-axis scale with text objects and place it over the real y-axis. Since the y-axis is always from 0 to 100%, you won't have a problem with things getting out of alignment.