|
楼主 |
发表于 2013-5-5 08:04
|
显示全部楼层
hwc2ycy 发表于 2013-5-4 15:41
你的表里有宏表。
直接把C定义成STRING类型,标题用公式来指定,或者指定TEXT也是可以的。
谢谢你帅哥,这个我也解决了。那段代码改成下面的就行了- Sub ChartAdd()
- Dim A As Range
- Dim B As Range
- Dim C As String
- Dim D As Range
- Dim Sh As Worksheet
- Dim myChart As ChartObject
- For x = 3 To Sheets.Count
- With Sheets(x)
- .ChartObjects.Delete
- Set A = .Range(.Range("A3"), .Range("A3").End(xlDown))
- Set B = .Range(.Range("H3"), .Range("H3").End(xlDown))
- C = .Cells(1, 1).Text
- Set D = .Range("A:A").Find("衰减系数", , xlValues, 1)
- If Not D Is Nothing Then
- Set myChart = .ChartObjects.Add(0, Cells(D.Row + 4, 1).Top, Range("A1:H1").Width, Range(Cells(D.Row + 4, 1), Cells(D.Row + 23, 1)).Height)
- With myChart.Chart
- .ChartType = xlLineMarkers
- .SetSourceData Source:=Sheets(x).Range("C42"), PlotBy:=xlColumns
- .SeriesCollection.NewSeries
- .SeriesCollection(1).XValues = A
- .SeriesCollection(1).Values = B
- .ApplyDataLabels ShowValue:=True
- .HasTitle = True
- .ChartTitle.Text = C & "瓦斯抽采衰减曲线图"
复制代码 |
|