Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
High guys on the below charts is the there anyway I can place the percentage of the number beside my total on the bars
Hi,
You have 2 expression: Sum(exp1); Sum(exp2); You have to uncheck Values on data point.
You can add a new expression:
NUM(sum(exp1)+sum(exp2),'#,###')&' '&NUM((sum(exp1)+sum(exp2))/(sum(sum(TOTAL exp1)+sum(TOTAL exp2)),'#,###.00%'). And to uncheck Bar and check Values on data point.
Good luck!
I don't see any difficult here, Can you attach sample application?
In expression =Dual(%expression , your normal expression )
enable show values on data points
The below link will help with an example:
Go to Chart Properties, Under Number tab, select the Expression and change it to Number and Enable 'Show in Percent'
You can change the Format pattern according to your decimal precision needed.