Tip #1095: Add percentage labels to pie charts

Welcome to chart week! This week on CRM Tip of the Day, Ulrik “CRM Chart Guy” Carlsson brings us a chart tip every day.

When you create a pie chart on the est. revenue on opportunities broken down by account, or any other currency field, the pie chart automatically displays the value of the slice in the label.

Sometimes, showing the percentage instead of the actual value can be useful. Especially as the pie chart is really intended to show the relative proportions of the individual groups.

Luckily it is very easy to change the labels from the long, two decimal values to a percentage value.

Open the XrmToolBox and open the Advanced Chart Editor. If you don’t have it, you can find it in the plugins store.

  1. Load the entities
  2. Select the opportunity entity to retrieve the charts. Or whatever entity the pie chart you are changing is on.
  3. Select the chart by clicking on the name so it is highlighted in blue.
  4. Then click on Edit Chart.

Click on Open Visual Editor.

Navigate to the series node and change the following values.

  • Font Type to Verdana
  • Font Size to 20
  • IsValueShownAsLabel to False
  • Label #PERCENT

Don’t forget to click Save, then click Ok, to get back to the standard editor.

Click Update

Your updates to the chart XML will now be updated directly in Dynamics 365 without needing the export/import of the XML file.

In Dynamics 365, open view and chart, or if already open, simply refresh the grid to see the updates.

9 thoughts on “Tip #1095: Add percentage labels to pie charts

  1. Jay says:

    This no longer works in the unified interface. I did this and it shows in the old ui, but not the new.

    • Jay says:

      Care to summarize?

    • Jay, you’re correct. The challenge with unifited interface is that it’s now using highcharts and not SSRS charts as it used to. That means that most of the customizations that involve modifications to chart xml, no longer work. With highcharts, in theory, everything is cutomizable, but customizer UX needs to catch up with the features.

  2. Yvan Leclerc says:

    What if we want to remove the decimals to the percentage value?

    35.07% -> Display as 35%


  3. nohoo says:

    This still work only thing you have do is manually change the IsValueShownAsLabel to False in the chart editor

  4. The XRMToolBox tool no longer works when editing with the UI, edit the value directly in the XML code instead.

    ‘IsValueShownAsLabel to False in the chart editor’ – This also worked for me

Leave a Reply

Your email address will not be published. Required fields are marked *