I have a thermometer chart in an excel file. I would like this chart to get the data from a separate excel file. Can this be done?
Perhaps I should explain what I am trying to do. I have a PowerPoint presentation that runs continuous on a LCD screen. One of the slides is this thermometer that shows our progress toward sales goals. I would like to update this chart without having to stop the presentation and reload a new slide. Any ideas would be appreciated.