You can follow the discussion on Google Sheets - How to Create Dynamic Ranges for Charts without having to leave a comment. Cool, huh? Just enter your email address in the form here below and you're all set.