Hi Y'all,
I have charts linked to a PowerPoint file that I need to update automatically when new data is entered.
I'm having trouble in two areas in the attached file at bottom.
1. ABI chart: Needs to keep data from 2010 - present (only add additional month's data automatically when entered)
2. Automotive chart: Needs to remove the oldest Month's Data from chart. & add the newest entered month's data.
Not sure best way to approach these. I tried formatting my data for ABI as a table but it's not auto updating.
Any helps much appreciated.
Thanks!
-Emili
Help Please.xlsx
Bookmarks