If PPM is changed to%, the chart will not work, the ordinate of the chart will be too large, and the generated chart will look short.
Second, the actual defect rate = total defect rate/total output * 1000000 PPM. I'll give you a formula for reference, because I don't know the cell address, so I put the result on C50, and then copy it to the cell you want after calculation. The formula is as follows:
= if error(INT(C63/C64 * 10000)，"")
If you have any questions, please contact me.