Why can't charts widget select columns from sheets?

Ryley

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?

Paul Newcome

You would need to create a row report that pulls from the sheet and then use that to create your chart.

Paul Newcome

You would need to create a row report that pulls from the sheet and then use that to create your chart.