Multiple Charts On Single Layout

[nesor]

I'm trying to create a dashboard consisting of several charts on a single layout. The issue I'm running into is that each chart requires the data to be sorted differently.

Example Dashboard:

Chart 1: Projects By Month (sorted by Month)

Chart 2: Projects By Sales Rep (sorted by Sales Rep)

Chart 3: Projects By Customer (sorted by Customer)

Any ideas on how to accomplish this? Thanks in advance!

[comment]

I don't think there's an easy way to do this. I'd probably script this, using "Fast Summaries" to collect the charted data.