Is it possible to create dashboard charts using Sheet Summaries?

Sara Henderson

I know Sheet Summaries can be used to create Metrics widgets, but when I try to create a chart, there is no option to select a Sheet Summary as a data source.

I thought the whole point of the summaries was to eliminate the need to add formulas and metrics on the sheet itself (or to a separate report). Am I missing something?

Heather Duff

I have not found a way to do that, unfortunately. I have had to create what I call Rollup sheets where I pull all of the summary formulas into a new sheet, then use that sheet as the source for all of my charts.

Vicky Athersmith

Hi Sara,

You can create a sheet summary report and then you will be able to select the report as your data source to create your chart in the dashboard.

Hope this helps. Vicky

jcurry

I have used the approach that Vicky described with success.