How-to Create a Dynamic Excel Chart that Only Displays Non-Blank Values
http://www.exceldashboardtemplates.com
How-to make a Dynamic Excel chart that doesn't show blank values so you don't have to use filters. It uses a combination of Index and Match functions along with an Offset function. More examples of Index/Match and Offset functions in Excel on my web page.