Automatic updating charts in excel
It would be really awesome if updating the excel document could automatically update the charts in the powerpoint presentation. Introducing the new extension to the Scrape HTML Add-In: Automatic Updating of Excel Worksheets.The pictures all need to be in a single folder, with the file name in the format “Employee Name.File Type” – for example, Jonathan (the name has to match the name in the data source exactly).On the first page of the wizard, select Information that's already stored in a file or database, then follow the directions in the wizard.The data source needs to have columns for employee name, unique identifier, and the person the employee reports to.
On the next page, select Delimited text, type a file name, and click Next.
Move related shapes near each other, and then add dotted-line connectors to show secondary reporting structures. Drag the Team Frame shape from the Shapes window onto the drawing, then use the sizing handles on the sides to make it include the individuals on the virtual team.
If new data doesn’t exactly match the data the chart was built with, you might have to move individuals manually.
It doesn’t matter what the column names are in the data source, because in the wizard you manually identify which columns (or field names) contain the employee name and the reports-to name.
The following text gives an example of a comma-delimited text file that has five columns and four rows, with the first row being a header row.