Thank you for the response, and sorry for the delayed response. It is good to know that the #N/A won't show in charts, however, in this case since this is for a dashboard I have an if statement to return blank if there is no data/title.

I'll look into the dynamic ranges... Thank you!