Is there a reason you need to use a chart? Can you just use a table with an aggregate model?

Pivot tables have been much discussed.  A single aggregate model will probably not deilver what John wants,  and he doesn’t want to create a new model for every column…   

So I’m changing this to an idea and would like your input into other use cases where this might be helpful…  We’d like your voice into how this might be delivered.