Interesting. Sounds a bit like this: www.thelogicalbox.com
Also a little like
http://www.sumwise.com/>“It’s really easy to build charts in Excel. But it’s really hard to get the data in the right format to do that,”
This is a famous spreadsheet problem. The only solutions I have seen are a bit like SQL. Hope you find a better way.
Err ... my interest: I am also working on a spreadsheet based startup, a web app builder for spreadsheet users.
Good luck, hope you add a solution or two to our world.