Bernhard says:April 28, 2022 at 6:03 pm
Thank you very much for this great blog.
I set up a pivot table in the second tab(sheet) of my two tabs(sheets) table upon the data of my first tab(sheet). In my first tab(sheet) of my table, where I have my "raw" data, I have cells with no value that represents 0 value. I mean, in the cells with value 0 I have empty cells. In the pivot table of the second tab(sheet) Google sheets fills this empty cells with "0" and therefore the line graph I set up with the data of this pivot table draws lines to the floor of the graph to represent this "0" cells.
As you know, there is not possible to delete this "0" value cells in the pivot table. And if I filter them I would be hidden values of the X axis. To format the "0" value cells of the pivot table for not to show the "0" is not working as the "0" value is still there although you can't see it.
Is there a way to sort this situation?
Thank you very much.Reply
Charles Zweifel says:February 10, 2021 at 11:23 pm
I am using a pie chart, showing % of "tasks" completed, not started, in progress, or impeded. When I change a status, it updates chart immediately which is all good. The problem is, if I use a filter on another row, say to see how a particular person is doing on executing/completing their tasks and hide the other employees, it seems to break the formula for the overall graph. I then re-populate (select all) the team's names in the filter, and the graph that comes back is either only showing some of the data, or in some cases gone completely.
I notice that if I have "blanks" in some of the rows (which I do) and keep "blanks" selected when I update status or a particular task, the data stays intact and transfers to the chart... If I de-select "blanks" in my filter, and make a change of status of any kind, the chart is either broken or disappears and has to be re-built. Is there a way to lock the graph into the main full document to keep from having to rebuild after each filter action?Reply