Sub Anzahl_Graphen() ActiveSheet.ChartObjects("Diagramm 1").Activate Msgbox ActiveChart.SeriesCollection.Count End Sub