|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
电脑专家俱乐部 发表于 2012-8-16 11:40
能不能在把添加数据标签加进去。怎么改啊
希望对你有用,呵呵。
Sub AddChrt()
Dim a As ChartObject
Dim FinalRow As Long
Dim FinalCol As Integer
Dim i As Long
FinalRow = ActiveSheet.Range("a" & Rows.Count).End(3).Row
FinalCol = ActiveSheet.Cells(1, Columns.Count).End(1).Column
If FinalRow <= 1 Or FinalCol <= 1 Then
MsgBox "请输入数据,谢谢!"
Exit Sub
End If
With ActiveSheet
.ChartObjects.Delete
For i = 2 To FinalRow
Set a = .ChartObjects.Add(100, 30 + (i - 2) * 200, 320, 200)
a.Chart.SetSourceData Source:=.Range(.Cells(i, 1), .Cells(i, FinalCol))
a.Chart.ChartType = xlLine
a.Chart.HasLegend = False
a.Chart.SeriesCollection(1).XValues = .Range(.Cells(1, 2), .Cells(1, FinalCol))
a.Chart.SeriesCollection(1).ApplyDataLabels ShowValue:=True
Set a = Nothing
Next
End With
End Sub |
|