I have a chart that displays the values found in cells A1:A5.
The values for these cells are numerical and formatted as percentage.
Currently,A1 thru A4 have numerical values (10%, 35%, etc) and A5 has no value for this month(the cell is blank)

I have added a chart table that individually maps each cell and the value in cells A1 thru A4 show up in the Chart Table as they should.
But in the Chart Table cell A5 shows up as 0% even though though cell A5 is blank

Is there a way make the chart display nothing opposed to the 0% it is currently displaying?