For i = 1 To ActiveSheet.ChartObjects.Count title = ActiveSheet.ChartObjects(i).Chart.ChartTitle.Text ActiveSheet.ChartObjects(i).Chart.Export ThisWorkbook.Path & title & ".png" Next i