rmccafferty
Board Regular
I have a master address list in a worksheet, and need to link that data. Now the problem is any blank cells in the sub sheet now has the zero in. Graphpad prism 8 for mac. I should also note that I am on a Mac, but do have access to Windows with Kutools for Excel. There is an option to not show zeroes in cells with zero as a value. Excel, Access, PowerPoint and Word Help Forum Help Section Excel Help Return blank cell instead of zero using GETPIVOTDATA (Excel for Mac 2011) If this is your first visit, be sure to check out the FAQ by clicking the link above.
Permission denied when mounting Docker volume in OSX. I'm at my wit's end with this, so hopefully you folks can help me. In OSX 10.11.2 with docker-machine, I've got a docker-compose file that should build a local Dockerfile and attach a MySQL container to it. First of all, please never run chmod 777 dir, it is insecure, change owner instead chown 999:999 dir. As I said before if I created the folder and set its permissions in advanced it will work, but because on Mysql Official Image it was not necessary. 
Expected behavior. I have a persistent volume defined, pointing to a directory on my host (macOS 10.13.2 running Docker Version 18.01.0-ce-mac48 (22004), ee2282129d, Kubernetes: v1.8.2), and a persistent volume claim, and a pod with a container that has a volume mount pointing to that PVC. Issues go stale after 90d of inactivity. Mark the issue as fresh with /remove-lifecycle stale comment. Stale issues will be closed after an additional 30d of inactivity. Prevent issues from auto-closing with an /lifecycle frozen comment. If this issue is safe to close now please do so.
My problem is that sometimes, some of the results are a zero. In the pie graphic, that is not an issue and there just is no slice for that component.
BUT, this still generates a label showing 0%. Which appears to relate to nothing.
Is there any way to have any labels with a zero value not appear? Either not be generated to begin with, or be formatted so as not to be visible? I cannot find any settings anywhere in Excel that indicated that this is even possible, let alone tell how to do it. Of course we could deleted those labels when they are zero, but that would make the chart not work correctly the next time we use it.
We do not want to eliminate the zero value cell in the supporting 'table.' For a variety of reasons. (For starters, we want the client to see the table form of the data and we want the slices referring to each specific 'variable' to always be the same color. I suspect other issues in formatting consistency would arise if we just removed a row of data.)
The chart is part of a financial planning workbook, with a lot of raw data entered about the person in an INPUT tab, and then all sorts of analyses and recommendations in additional tabs based upon the INPUT tab.
The point is that we would look to use the spreadsheet over and over again and would prefer not to have to manually format any part of the pie chart to cater to specific data input.