Forum Discussion

RoniGman's avatar
RoniGman
Copper Contributor
Mar 14, 2024

Auto Chart Creations/Update

- On Sheet 1 there is new data added in everyday.

- The new data is completely new - as in, not more rows are added to a table or anything. A new table is added everyday. Also, the number of rows of tables may differ and are not constant day-to-day.

- On Sheet 2, I'd like a new chart everyday to appear, all the while keeping old charts.

- The chart from Sheet 2 is copied automatically to PowerPoint 1 - either as a chart or an image. Image is preferable. The owner of PPT1 and Workbook are different people, but on the same company. 

 

I am 90% sure that this is not possible, but threw it out here anyways so some Excel Gods can tell me whether I'm asking for too much!

excel

1 Reply

  • Whitoke's avatar
    Whitoke
    Brass Contributor
    Aug 13, 2025

    You can use Excel's table function to automatically link chart data, or use VBA scripts to refresh it in real time:

    Private Sub Worksheet_Change(ByVal Target As Range)  
    If Not Intersect(Target, Range(Data Range)) Is Nothing Then  
        ActiveSheet.ChartObjects(Chart Name).Chart.Refresh  
    End If  
End Sub

     

Resources