|
发表于 2014-2-9 18:47
|
显示全部楼层
本楼为最佳答案
本帖最后由 suye1010 于 2014-2-9 18:52 编辑
- Sub AddRadarChart()
- Dim i, sha
- 'Remove existed charts
- For Each sha In ActiveSheet.Shapes
- If sha.Type = 3 Then sha.Delete
- Next
- 'Add new chart
- With ActiveSheet.ChartObjects.Add(100, 100, 500, 500).Chart
- .ChartType = xlRadar
- .SeriesCollection.NewSeries
- .SeriesCollection(1).Name = "Target"
- .SeriesCollection(1).Values = Array(10, 10, 10, 10, 10, 10, 10, 10)
- For i = 8 To Cells(65536, 7).End(xlUp).Row
- .SeriesCollection.NewSeries
- .SeriesCollection(i - 6).Name = Cells(i, 7)
- .SeriesCollection(i - 6).Values = "='Supplier Overview'!$H$" & i & ":$O$" & i
- Next i
- .FullSeriesCollection(1).XValues = "='Supplier Overview'!$H$5:$O$5"
- .HasTitle = True
- .ChartTitle.Text = "Supplier Review"
- End With
- End Sub
复制代码
副本Book1.zip
(17.04 KB, 下载次数: 28, 售价: 1 个金币)
|
|