How to Customise Advanced Reports Pie Charts to Show Colours and Values Instead of Percentages

Problem

When working with Advanced Reports Pie Charts, each element on the chart and the Legend show only percentage values by default after the initial creation.
Obviously, it would be more informative to see the actual values for each sector in the Pie Chart.
A similar request is also applied to the Legend.

Solution/Task

We need to adjust the visual output to show the colours assigned to each element on the chart body, along with the specific values (e.g., meters, in this example case).
The Legend should also show the names of the Pie Chart sections in matching colours.

Steps

Follow the steps below to customise the chart legend to display colours and values:

1. Click on the chart area and then the cog icon to make the “Chart Tasks” menu visible on the right.
   
   
   
   
2. Click the “Series…” link to call the “Series Collection Editor” pane on the right.
   
   
   
   
   
   
3. Click on the “Legend Text Pattern” property on a Property Tab.
   
   
   
   
4. This opens the “Pattern Editor” dialogue box for customising legend text labels. Click on the “Argument” placeholder.
   
   
   
   
5. Click on the [>] button to copy the selected Placeholder (“Argument”) onto the Pattern list.
   
   
   
   
6. Click the OK button to close the “Pattern Editor” dialogue box.
   
   
   
   
7. On the Section “Elements”, click and expand the “Label” element.
   
   
   
   
8. Click on the “Text Pattern” property.
   
   
   
   
9. The Pattern Editor form will open. Select the “Value” Placeholder.
   
   
   
   
10. Click on the [>] button to copy the selected Placeholder (“Value”) onto the Pattern list.
    
    
    
    
11. Click the OK button to close the “Pattern Editor” dialogue box.
    
    
    
    
12. Click the “Close” button to return us to the main Chart Designer screen, where the new text pattern formatting for data labels on the pie chart will be applied.
    Everything now appears as we defined it in the Task section.
    
    

Additional Notes:

• You can further customise the appearance of your labels (colour, font, size) within the “Series Collection Editor” for optimal readability and visual style.
• The “Pattern Editor” offers various placeholders for flexible formatting. Experiment to find the ideal display for your chart.

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access