Formating the values in a Pie Chart


Author
Message
Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K

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
Jay Guiang
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
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).
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search