Is it possible to create dashboard charts using Sheet Summaries?

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?
Answers
-
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.
-
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
-
I have used the approach that Vicky described with success.