A AbhijitV New Member Aug 11, 2015 #1 Request your help for automatic updation of data lables in the chart. Data labels includes amount in Rs mn and % . File is enclosed for perusal. When I am changing the amount, amount and % should be automatically changed in the chart Please provide the solution Attachments Chart example.xlsx 282.3 KB · Views: 3
Request your help for automatic updation of data lables in the chart. Data labels includes amount in Rs mn and % . File is enclosed for perusal. When I am changing the amount, amount and % should be automatically changed in the chart Please provide the solution
Chihiro Excel Ninja Aug 11, 2015 #2 You need a helper column. In Helper column use something like =TEXT(ROUND(B5,2),"0.00")&CHAR(10)&"("&ROUND(C5,0)&"%)" and "Wrap Text". Then highlight each data label, go to formula bar and reference corresponding cell in the helper column. Attachments Chart example_Helper.xlsx 248.3 KB · Views: 7
You need a helper column. In Helper column use something like =TEXT(ROUND(B5,2),"0.00")&CHAR(10)&"("&ROUND(C5,0)&"%)" and "Wrap Text". Then highlight each data label, go to formula bar and reference corresponding cell in the helper column.
A AbhijitV New Member Aug 11, 2015 #3 Chihiro said: You need a helper column. Thanks a lot Chihiro for the solution Click to expand...
