Why can't charts widget select columns from sheets?

I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs would update in perpetuity. Am I missing something or is there fix?

Best Answer