How do I show % in Barchart? - Updated..

[#1]

I have the following Barchart

If I create a separate chart for % it will be look like below

I want to combine this two (show numbers and % with in bar chat) into one chart. How do I do it?

Thanks

[#2]

Having both expression  in one chart (with toggle if needed) is one way to show both. If you want one bar with both values since one bar can have only one value one expression is to be made transparent. Like a combo chart with expression one as bar, expression two as line with value on data points, two  scales and making 2nd expression color transparent.

Kiran Rokkam

[#3]

Hi Kiran,

Thanks for the reply. At present I have a expression for individual bars. Also the upper limit is 355 for Y axis and if we add additional bar with % may not work.

Basically I want the chart look like below. How do I?

[#4]

Write a % expression as line chart, enable value on data points and expression color transparent.

Regards,

Kiran

[#5]

Kiran

Color Transparent: Where I should set? I tried clicking the Properties->Color->  then moving transparency slider from 0% to 100%. It is not helping.

ALso the values are overlapped. see below chart.

[#6]

I thought your bars represent one expression. Since each bar itself is an expressions my earlier suggession wont work . The option I see now is using text in chart. If I find another way I shall post.

Kiran.

[#7]

I noticed there is a function called DUAL. Do you know whether I can use this in Barchart? How do I?

[perumal_41]

Hi

can u Upload ur file .so that i can try to  work  and find a solutions for ur query?

Regards,

Perumal

[#9]

Hi Perumal

Thanks for the help. Here is the file

Perumal A wrote:

Hi

can u Upload ur file .so that i can try to  work  and find a solutions for ur query?

Regards,

Perumal

[perumal_41 · Accepted solution]

Hi.

I attached one file .please check it is correct or not .