Category "Labels" not displaying on Pie Chart


Author
Message
Steve Murray
Steve Murray
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
That was too easy!  I wish the online documentation said "How to obtain 2 or 3 line labels" on your charts.  In the expression editor for Data Labels, press enter and add a second line.  I looked everywhere in the online documentation.  Off and running, thanks!
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
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


Steve Murray
Steve Murray
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
Good news!  Chart is working properly.  Still don't know how to make the Labels appear on two lines.  Many thanks for your help.  You guys are awesome!https://www.nevron.com/forum/uploads/images/c5e91088-e6de-4e90-8812-11b7.png
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
Hello Steve,
Thank you for providing the sample data. Following is the resulting Pie chart:
https://www.nevron.com/forum/uploads/images/dd0e3917-9f42-48b1-a7ab-01c7.png

Attached, you can also find the chart template file.
Let us know if you have any questions or if you need assistance.


Best Regards,
Nevron Support Team


Attachments
NChart_Pie.ncsp (638 views, 1.00 MB)
Steve Murray
Steve Murray
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
Attached is Jan/Feb data from Sharepoint list.  When creating a chart, I set a filter for Iphone charges. 
Thanks for the helping hand(mind)!

Attachments
GSM Charges.xls (863 views, 352.00 KB)
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
Steve,
Can you send a snapshot of your data (in Excel spreadsheet). We are going to prepare an example for you.


Best Regards,
Nevron Support Team


Steve Murray
Steve Murray
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
https://www.nevron.com/forum/uploads/images/44c53323-f2ca-4c43-aa25-a51d.pngI am still not able to pass labels to the Label: or the Legend.
Expression appears to work correctly as the percentages are correct. Below is the expression and a picture of the chart.
https://www.nevron.com/forum/uploads/images/b0aa5025-0fe7-4515-b350-94da.png
Steve Murray
Steve Murray
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
https://www.nevron.com/forum/uploads/images/f0eabcc0-a23a-4cc6-b360-f0c2.pngStill no joy yet.... This seems to be a pretty straight forward chart; however, I am unable to "pass" the filter criteria labels to either the Legend or the pie chart Data Labels. 
Copy of chart w/o labels and logic.https://www.nevron.com/forum/uploads/images/27601ef9-2a2d-4a9f-8445-f29f.png
Steve Murray
Steve Murray
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
https://www.nevron.com/forum/uploads/images/92a74520-af5e-42ef-88bc-c768.pngNo joy yet.  Attached is the requested information.
https://www.nevron.com/forum/uploads/images/d827c257-383e-486e-9d54-208b.png
Steve Murray
Steve Murray
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
Thanks.... I tried your "First" suggestion.... no joy.  I have attached a snapshot and a copy of November's data (minus cell number, department, name.)  Appreciate your help.https://www.nevron.com/forum/uploads/images/68bc81a7-2c07-46b9-ac0a-80a8.png
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