excel:获取当前图表的索引

Question

我创建了一个新图表

Sheets("DatenFilledChart").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlArea
ActiveChart.SetSourceData Source:=Range("DatenFilledChart!$B$4:$B$1004")
ActiveChart.SeriesCollection(1).XValues = "=DatenFilledChart!$A$4:$A$1004"
ActiveChart.SeriesCollection(1).Name = "=DatenFilledChart!$B$1"

为了使用当前图表，我想保存其索引

indexOfChart = ActiveChart.Index

但是失败了

The method Index is invalid for a object _Chart

我做错了什么？

Answer 1

尝试使用这个:

indexOfChart = Shapes.Count

而不是

indexOfChart = ActiveChart.Index

Index 属性不适用于图表集合:

Index Property

The position of a Tab object within a Tabs collection or a Page object in a Pages collection.

了解更多:http://msdn.microsoft.com/en-us/library/office/ff194426.aspx