Using entire columns to create dashboards in lieu of cells

Luis Perez

I am tryin to create a dashboard that tracks a trend over time (weeks). It is pulling from a sheet where we document production week to week. I'd like to create a dashboard that will pull from the entire columns so that when I add future data it will automatically pull into the dashboard.

So far it seems that I have to manually select the cells I want to pull data from.

Is setting column as a data source for a dashboard possible?

Genevieve P.

Hi @Luis Perez

You can use a Report as a source for a Chart!

When a Report is selected as a source, the entirety of the content is used in the Chart (you cannot select specific cells). This means that as new rows are added to the sheet they will automatically appear in the Report, which will then automatically update the Chart.

See: Using Chart Widgets

Cheers,

Genevieve