Reports as Metric Sheets

Hi there,

Is there anyway to use a Report to make chart widgets on a dashboard? I would normally create a metric sheet and use formulas to count items I wanted to illustrate in chart form, but have not been able to do that with a report.

I have one report that contains over 90 sheets and really don't want to have to build that really long COUNTIF formula from all those sheets if I can avoid it.

Any help would be great.