Chart %

[#1]

Hi All,

I have data as under.

load *

inline

[exp,amt

Gros, 20

Travel,50

Ent,20

others,10

];

I want to plot a chart for total exp is 100, on each expense i want to show % of total exp by category

Gros is 20% of total expense,

Travel is 50% of total exp

Please help.

Thanks..

[mphekin12]

Use 'exp' as your dimension and '=amt/sum(all amt)' as your expression.  On the 'Number' tab click 'Show in Percent'.  Hope that helps.

[manojkvrajan]

Attached is the sample to display both Amount and Amount %. I hope it helps.

[#4]

Thank you, i used that. It works,

I am sorry, I was not clear. I want to show bar with different color of %.  all bar has same color for total and then % of color will be different based on category.

Lets say total amt barr is blue and i eant to change 50% bar to green for travel category. so my bar will look half green and half blue. I am trting with back ground color, but some how not getting it.

[#5]

Seems quite simple.

In Dimension, you select 'exp'

In expression, use this formulae: amt/sum(all amt). It would display in decimal value. If you want in %, go to Number format and select 'Fixed To' and enable the Show in Percent(%).

Please check.

[#6]

Thank you, i used that. It works,

I am sorry, I was not clear. I want to show bar with different color of %.  all bar has same color for total and then % of color will be different based on category.

Lets say total amt barr is blue and i eant to change 50% bar to green for travel category. so my bar will look half green and half blue. I am trting with back ground color, but some how not getting it.

[mphekin12]

Will something like this work?

[#8]

Thanks,

I think this is what i wanted but value on data point doen't show for individual. I am not sure may be it is hiddle under becuase of stacked char. Am I missing anything here.

PLease let me know.

[mphekin12 · Accepted solution]

Here it is with different colors and text on axis.

[#10]

thank you so much. I wanted to show it at data point but shome how it is not showing.