I would suggest to use NA()

=IFERROR(SUM(D8/E8)*1000,NA())

This way your chart will look nicer. Also, use Conditional Formatting to hide errors