|
Group: Forum Members
Last Active: 10 Years Ago
Posts: 1,
Visits: 3
|
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).
|
|
Group: Forum Members
Last Active: Last Week
Posts: 3,054,
Visits: 4,009
|
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.
Best Regards,
Nevron Support Team
|