It seems that the only way to achieve that is hiding the row/column with the 0%, so the graph will not include that value.
This can be done automatically. I found an example on the web:
Right click on the Sheet name tab and select “View Code”.
Then paste the following code and press ALT+Q to save.
<pre>Private Sub Worksheet_Calculate()
On Error Resume Next
(xlCellTypeFormulas, xlErrors).EntireRow.Hidden = True
(xlCellTypeFormulas, xlNumbers).EntireRow.Hidden = False
This code will hide the complete row when the cell in column E (5) has an error, so you could add a formula in the PTP% column similar to this:
When SUM(U166-U175-U171)=0 then this row will be hidden (and the graph will not include it), and when the value is different from 0 it will be un-hidden.
If your PPT% data is not in the E column you should modify the above code
I did a small test, and it worked.
Hope this helps.