Profile Picture

Formating the values in a Pie Chart

Posted By Jay Guiang 10 Years Ago
Author
Message
Nevron Support
Posted 10 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Yesterday @ 1:38 AM
Posts: 3,054, Visits: 4,006

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



Jay Guiang
Posted 10 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)

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).



Similar Topics


Reading This Topic