Profile Picture

Category "Labels" not displaying on Pie Chart

Posted By Steve Murray 9 Years Ago
Author
Message
Steve Murray
Posted 8 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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
Posted 8 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Yesterday @ 1:54 AM
Posts: 3,054, Visits: 4,009
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
Posted 8 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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
Posted 8 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Yesterday @ 1:54 AM
Posts: 3,054, Visits: 4,009
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 (567 views, 1.00 MB)
Steve Murray
Posted 8 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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 (740 views, 352.00 KB)
Nevron Support
Posted 8 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Yesterday @ 1:54 AM
Posts: 3,054, Visits: 4,009
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
Posted 8 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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
Posted 9 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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
Posted 9 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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
Posted 9 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 7 Years Ago
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



Similar Topics


Reading This Topic