I have a pie chart that shoes the % of total revenue that comes through various revenue channels e.g. web, phone etc. I use the expressions to calculate the % of total revenue that will be seen in the chart.
I want to then to add the labels to the chart but show the % value for each segment and not the revenue source figure. At the moment I have achieved this through writing a formula in the 'text in chart' option. This produces exactly what i want except that the text in chart value is in a fixed position and does not move in relation to the size of the segment. So often the correct label is not actually in the segment it represents. Is there a better way to do this? Can I put values of the data points but be shown as a % rather than the actual £ figure?
I hope the above makes sense.