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