Forum Discussion
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...
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