Pivot Chart Do Not Plot Zero

Pivot Table isn't meant to deal with blank data.

If you must, you can filter out based on value field.

However, since you have multiple value field, better method is to filter out blank ranges from PivotTable range rather than load blanks.

How you'd achieve this will depend on few things. Two that's easy to do are...

1. If you have access to PowerQuery, this can be easily be done with filter operation withing PQ editor.

2. Define dynamic named range to find last non-blank row for Total column and define data source range for PivotTable.

See attached for sample using 2nd method.