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?
Tags:
Best Answer
-
You would need to create a row report that pulls from the sheet and then use that to create your chart.
Answers
-
You would need to create a row report that pulls from the sheet and then use that to create your chart.