Pie Chart Legend
I have created a report with a number of pie charts, the scale of each pie chart is the same (1 - 6).
My problem occurs when not all answer options are selected for each question, this then only displays the colours of the select responses and not all of the possible answer options within the legend thus causing the colours to relate to different answers options within each pie chart.
Is there a way to display all answer options within the pie chart legend irrespective of whether there is an answer supplied?
|