Profile Picture

Formating the values in a Pie Chart

Posted By Jay Guiang 6 Years Ago
Author
Message
Jay Guiang
Posted 6 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: 6 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).

Nevron Support
Posted 6 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)

Group: Forum Members
Last Active: Last Week
Posts: 2,888, Visits: 3,074

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





Similar Topics


Reading This Topic