Tag Archives: presentation

Automate Excel charts building and moving to Power Point presentations

Hi,

Today we would like to present you yet another Excel add-in that we created for one our client. This is another implementation of the tool to build and transfer Excel charts into PowerPoint presentations.

The tool is quite universal so you could easily adapt yourself to use it.
The solution is quite simple and it uses at maximum the natural capabilities of Excel.

So, imagine you have a huge set of data which you have to analyse somehow, create charts on separate subsets of data and transfer them into PowerPoint presentations to then submit them to your clients. With this add-in you are actually supposed to have
– a table with data
– an area where you can insert row numbers
– an area that is filled dynamically with data by means of formulas and that takes a row number as an input
– sheet charts that have as data source the before mentioned area

Continue reading Automate Excel charts building and moving to Power Point presentations