dtrots Posted December 3, 2011 Share Posted December 3, 2011 I have a straight forward pie chart but this is escaping me for some reason. I have a pie chart with 4 fields for data. There will be some instances where one or two of the fields will be zero. How would a calculation look that would exclude the "zero" data so the pie chart labels don't look bunched together? I have a bunch of "is empty" or "if"'s in my head but I must be missing the simpler solution. Thanks in advanced (see attachment to see what I'm talking about) Link to comment Share on other sites More sharing options...
comment Posted December 3, 2011 Share Posted December 3, 2011 I have a bunch of "is empty" or "if"'s in my head but I must be missing the simpler solution. I don't think so - at least not with your current structure. Link to comment Share on other sites More sharing options...
JerrySalem Posted December 9, 2011 Share Posted December 9, 2011 I am not sure how your current calculation is for the Labels but I would use this; If(Labor;"Labor¶";"") & If(Material;"Material¶";"") & If(Equipment;"Equipment¶";"") & If(Subs;"Subs";"") See the attached example. Jerry PieChartTest.fp7.zip Link to comment Share on other sites More sharing options...
dtrots Posted December 11, 2011 Author Share Posted December 11, 2011 Jerry Thank you so much. Always great to learn something new. Dave Link to comment Share on other sites More sharing options...
Raybaudi Posted December 11, 2011 Share Posted December 11, 2011 The calculation for "Categories Better" could be: List ( If ( Labor ; "Labor" ) ; If ( Material ; "Material" ) ; If ( Equipment ; "Equipment" ) ; If ( Subs ; "Subs" ) ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4521 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now