In Excel I'm using the Microsoft-recommended method in a pie chart to prevent non-zero data source values from displaying. This method takes advantage of the fact that Excel automatically excludes #N/A values from charts. Using the "NA()" function within an IF statement in every data source cell formula will control whether the value gets displayed. The problem is that PlanMaker HD for tablets doesn't ignore #N/A results for charts the same way Excel does, and it displays overlapping "0%" data labels.
This may affect other types of charts as well, but I haven't tested them.
This behavior also occurs in PlanMaker Mobile Free for Android phones, plus that same app also displays a "Chart Title" even though the title element doesn't exist.
I'll send an example file to the forum address.
Thanks,
-bsbdd
Pie Charts - Zero Values [SOLVED]
Pie Charts - Zero Values [SOLVED]
Last edited by bsbd on Mon Dec 07, 2015 9:31 pm, edited 1 time in total.
Re: Pie Charts - Zero Values
The developers solved that problem. It should no longer occur in the next service pack.
Sven Leßmann
SoftMaker Software GmbH
SoftMaker Software GmbH
Re: Pie Charts - Zero Values [SOLVED]
Update 749 has cleaned this up. Thanks.
-bsbd
-bsbd