If you get errors in your results in Excel, edit your formula so it starts with the 'IfError' formula. You can 'nest' an If Error formula and another formula to remove the error messages and it will look so much better

Channels vs. Site Library Explained in One Minute

The quickest way is to apply a filter to the visualization..