is there a way of dynamically changing a format of a bar chart depending on its values....
some rows of data are for percentages
1)Attaintment in 75%
2)Sales in 1008 number value
when user select Attainment bar should be in % when user selects sales it should be number
i tried using the option
=NUM( (sum(sales)/Sum(target))*100, '##.##%','.',',')
=NUM( (sum(sales)/Sum(target)), '##,00%',',','.')
= values &'%'
same expression in working in text box but not working in line chart. i have set the formatting to 'AUTO'.
Please suggest an option to fix the issue