在散点图的绘图区中添加一个文本框:
Sub Test()
On Error Resume Next
Sheet1.ChartObjects.Delete '清除所有chart
'查入一个散点图
Dim Cht As Chart
Set Cht = ThisWorkbook.Charts.Add
Cht.ChartType = xlXYScatter
Cht.SetSourceData Source:=Sheet1.Range("a1:a9")
Cht.Location Where:=xlLocationAsObject, Name:="Sheet1"
Set Cht = Nothing
'在散点图上添加画文本框
Dim cTxt As Shape
Set cTxt = ChartObjects(1).Chart.Shapes.AddTextbox(msoTextOrientationHorizontal, 50, 50, 100, 30)
cTxt.TextFrame.Characters.Text = "Hello,你好吗?"
Set cTxt = Nothing
End Sub