Formating the values in a Pie Chart


https://www.nevron.com/Forum/Topic8626.aspx 		Print Topic | Close Window

By Jay Guiang - 10 Years Ago
How can I format the labels that are displayed in the pie chart? For example, I want the labels on the pie chart to format the values to currency. When I use , it displays it as a full number (ie. 603893, as opposed to $603,893).
By Nevron Support - 10 Years Ago

Follow these steps:

1. For the Label value in the Pivot - Values - General tab enter this expression:
=FORMAT(SUM(Fields!MyField), "C")
this expression will format the label of the data point to show as currency.

2. For the Format value in the Pivot - Values - Data Labels tab enter this expression:
<label>
this instructs the chart to show only the label for each data point.

Hope this helps - questions or comments - please feel free.