I've moved this over to our Server Admin Group as this seems like the type of questions that admins would be better suited for. I don't have any experience doing what you've asked but I'm definitely curious to see any workarounds.
You could also post an instructional workbook with annotations about what to do to manipulate the viz. Just a thought.
I've seen the dynamic chart type thing done here: