Private Sub worksheet_change(ByVal target As Range)
Call test
End Sub
Sub test()
With ActiveSheet.ChartObjects("图表 4").Chart.SeriesCollection(2)
For i = 1 To 3
.Points(i).DataLabel.Characters.Text = Cells(15, i + 4)
Next i
End With
End Sub
Private Sub worksheet_change(ByVal target As Range)
Call test
End Sub
Sub test()
Dim i As Integer
Dim rng As Range
With ActiveSheet.ChartObjects("图表 4").Chart.SeriesCollection(2)
For i = 1 To 10
Set rng = Cells(15, i + 4)
If VBA.IsNumeric(rng) Then .Points(i).DataLabel.Characters.Text = rng Else Exit For
Next i
End With
End Sub
爱疯 发表于 2016-1-21 14:38
Private Sub worksheet_change(ByVal target As Range)
Call test
End Sub
还有件麻烦事
Private Sub worksheet_change(ByVal target As Range)
ActiveSheet.ChartObjects("图表 4").Chart.Axes(xlCategory).MaximumScale = [i33]
Call test
End Sub
Sub test()
Dim i As Integer
Dim rng As Range
With ActiveSheet.ChartObjects("图表 4").Chart.SeriesCollection(2)
For i = 1 To 10
Set rng = Cells(15, i + 4)
If VBA.IsNumeric(rng) Then .Points(i).DataLabel.Characters.Text = rng Else Exit For
Next i
End With
End Sub
我加了句 ActiveSheet.ChartObjects("图表 4").Chart.Axes(xlCategory).MaximumScale = [i33]
这个,如果附件里的第一个表格更改级配属性,为什么报告表不自动更换呢,如原来的是37.5,31.5...更改为53.37.5,31.5...第一个表改动,报告表的图表不自动更改啊
Private Sub Worksheet_Activate()
Call test
End Sub
Sub test()
Dim i As Integer
Dim rng As Range
With ActiveSheet.ChartObjects("图表 4").Chart
.Axes(xlCategory).MaximumScale = [i33]
For i = 1 To 10
Set rng = Cells(15, i + 4)
If VBA.IsNumeric(rng) Then .SeriesCollection(2).Points(i).DataLabel.Characters.Text = rng Else Exit For
Next i
End With
End Sub 水泥混凝土用粗集料试验检测报告记录2.rar(30.27 KB, 下载次数: 11)