Pie Chart Label on Percentage

Question

Pie Chart Label on Percentage

Louis_See

Grasshopper

Points: 11
More actions
October 31, 2005 at 2:28 am

#111173

Anyone can tell me how to label pie chart with percentage on the chart. there is a selection in MS excel but can't find in RS.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Syed Asim Rizvi Ten Centuries Points: 1112 More actions · Answer 1

To present values in percentage, you need to make sure in "Point Labels" tab of Chart Properties, value of "Data Label:" should be something like "=((Fields!my_field.Value) / (Sum(Fields!my_count.Value, "my dataset"))) ".

RS itself multiply converted number by 100 in order to be presented as a percentage.

Next, the "Format Code" should be like "p00", where "p or P" is format code for percentage and "00" is the precision specifier indicates the desired number of decimal places. (use your desired precision)

Hope this will help.

Vivienne Boogaard-235180 Newbie Points: 8 More actions · Answer 2

You also have to calculate the percentage yourself, RS will not do it for you given the raw numbers.

Syed Asim Rizvi Ten Centuries Points: 1112 More actions · Answer 3

Nopes , if you specify "P" as format code, RS itself multiply by 100, but the other half of percentage calculation, you have to do it yourself and thats exactly what I'm doing here:

"Data Label:" should be something like "=((Fields!my_field.Value) / (Sum(Fields!my_field.Value, "my dataset"))) ".