I have a series of charts in powerpoint that are linked to an excel sheet. I have it built so when i add new data each month it automatically updates the charts in powerpoint. The issue i came across was I have it built out to the end of the year, and for the months with out any data yet, the chart shows blank sections. I found that if I hide the columns on the excel sheet the powerpoint chart will only show the available data. So i plan to just unhide the new month to update data as i need. But then i noticed that while the data on the powerpoint chart updates the new month does not appear until i click refresh data. So I am trying to figure out a refresh all solution. Or if there is a better way to not show the blank data i am open to that as well.

Thanks in advance for any help