Pie Charts - Zero Values [SOLVED]

Post your questions, bug reports and suggestions here for PlanMaker HD for Android.

Moderator: SoftMaker Team

Post Reply
bsbd
Posts: 39
Joined: Fri Apr 03, 2015 5:51 pm

Pie Charts - Zero Values [SOLVED]

Post by bsbd » Sun Oct 11, 2015 6:31 pm

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
Last edited by bsbd on Mon Dec 07, 2015 9:31 pm, edited 1 time in total.

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7884
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Pie Charts - Zero Values

Post by sven-l » Mon Nov 02, 2015 11:33 am

The developers solved that problem. It should no longer occur in the next service pack.
Sven Leßmann
SoftMaker Software GmbH

bsbd
Posts: 39
Joined: Fri Apr 03, 2015 5:51 pm

Re: Pie Charts - Zero Values [SOLVED]

Post by bsbd » Mon Dec 07, 2015 9:31 pm

Update 749 has cleaned this up. Thanks.

-bsbd

Post Reply

Return to “PlanMaker HD”