Hi,

You can definitely use VBA to for fully manipulating data both in Excel and PowerPoint. I would assume you could also control PowerPoint data model from Excel VBA, or the other way around, the similar way you can use both of these apps from an external VB.NET application. That will require some programming though.

Or you could use some intermediate format for the data - thinking saving your Excel data as XML or CSV files and then reading that in (and visualizing) through a PowerPoint VBA macro.