Hi,
Hope your issue got resolved. If not, then you can create a workflow in sharepoint designer or you can use Nintex workflows.
This way you can create form, email it to users, get info in the list/library and then finally use it for creating graphs, dashboards etc.
Hope this helps!