Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have plotted the values in my chart but in addition I would like to put the % in the legend..
Also, I have month as my dimension and reference numbers as expression (count), can anyone tell me how I can get the relative figure to add up to 100% per month rather than the total in the data set.
Many thanks all,
Matt
can anyone help?
Hi Matt,
To the first question, make your expression labels in the chart properties, Expressions tab, have the expression for the percentage. As a very basic example, the following should go in the expression label:
='Sales % is ' & Num(Sum(Sales) / Sum(TOTAL Sales), '#.##0,00%')
To the second, it depends on how you are creating your chart. Can you upload an example with dummy data on what you already have and what do you expect?
Hope that helps.
Miguel