Are there any best practices around manipulating the info in charts and graphs? It'd be great if there was some sort of pivot table functionality for users.

After much trial and error the chart functionality is only moderately useful and if you want something more you're likely going to have to export it out of Workfront and import it into another system.