Category "Labels" not displaying on Pie Chart


Category "Labels" not displaying on Pie Chart
View
Options
Author
Message
Steve Murray
Steve Murray
Steve Murray
posted 10 Years Ago HOT
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)
Group: Forum Members
Posts: 17, Visits: 79

I am unable to pass the "Label" from a Category Data Grouping.  I am grouping by Category to distinguish costs:
Labels are "Less than 20 OMR", "Between 20 and 35 OMR" and "Greater than 35 OMR".  The logic for each of the Category groupings is working fine e.g. (=Fields!Total_Current_Charges<20) and displays the <value> and <percent>, but the Label I assign to each Category grouping does not get passed back to the chart.  Below is a screenshot of my configuration.
Thanks in advance!
https://www.nevron.com/forum/uploads/images/9a1ef547-9751-418d-867a-0309.png
Reply Like 0
Reply
Nevron Support
Nevron Support
Nevron Support
posted 9 Years Ago
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
Hi Steve,
We are glad that we were able to help.
To have the labels on two, or multiple lines, you simply need to break the line in the expression editor like this:
=IF(FIRST(Fields!Total_Current_Charges)<20, "Less than 20 OMR",
IF(FIRST(Fields!Total_Current_Charges)>35, "Greater than 35 OMR", "Between 20 and 35 OMR")) + "
" +
FORMAT(SUM(Fields!Total_Current_Charges), "N0", "en-us") + "
" +
FORMAT((SUM(Fields!Total_Current_Charges)/SUM(Parent.Fields!Total_Current_Charges)), "P0", "en-us")

Best Regards,
Nevron Support Team
Reply Like 0
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
Category "Labels" not displaying on Pie Chart
Steve Murray - 10 Years Ago
     You can’t pass category labels to the pie chart data labels like that....
Nevron Support - 10 Years Ago
     Thanks for your prompt reply. I made the recommended changes...
Steve Murray - 10 Years Ago
             This is because the expression returns an array. Can you send a...
Nevron Support - 10 Years Ago
     Thanks.... I tried your "First" suggestion.... no joy. I have attached...
Steve Murray - 10 Years Ago
     No joy yet. Attached is the requested information.
Steve Murray - 10 Years Ago
     Still no joy yet.... This seems to be a pretty straight forward chart;...
Steve Murray - 10 Years Ago
     I am still not able to pass labels to the Label: or the Legend....
Steve Murray - 9 Years Ago
             Steve, Can you send a snapshot of your data (in Excel spreadsheet). We...
Nevron Support - 9 Years Ago
     Attached is Jan/Feb data from Sharepoint list. When creating a chart,...
Steve Murray - 9 Years Ago
             Hello Steve, Thank you for providing the sample data. Following is the...
Nevron Support - 9 Years Ago
     Good news! Chart is working properly. Still don't know how to make the...
Steve Murray - 9 Years Ago
             Hi Steve, We are glad that we were able to help. To have the labels on...
Nevron Support - 9 Years Ago
     That was too easy! I wish the online documentation said "How to obtain...
Steve Murray - 9 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Login

Explore
Messages
Mentions
Search