麻辣家族討論版版 - Powered by Discuz! Board

複製代碼

Option Explicit
Sub Ex()
Dim AR, i As Integer
With Sheet2.ChartObjects(1).Chart
.HasTitle = True '圖表有的標題
.ChartTitle.Font.Size = 6.5 '標題字體大小
.ChartTitle.Characters.Text = "test"
.ChartTitle.Font.Name = "Arial" '標題字型
.Legend.Position = xlLegendPositionBottom '圖例列底部
.Legend.Top = 115 '圖例位移
AR = Array(vbBlack, vbRed, vbGreen, vbYellow, vbBlue, vbMagenta, vbCyan, vbWhite)
For i = 1 To .SeriesCollection.Count
If i <= UBound(AR) + 1 Then
.SeriesCollection(i).Border.Color = AR(i - 1) '線條顏色
.SeriesCollection(i).HasDataLabels = True
.SeriesCollection(i).DataLabels.Font.Size = 15 '上列數值字體大小
.SeriesCollection(i).DataLabels.Font.Name = "Arial" '上列數值字型
End If
Next
End With
End Sub

複製代碼

Option Explicit
Sub Ex()
Dim MoObject As ChartObject, MoChart As Chart, i As Integer, Rng As Range
Dim Q(1 To 2)
Sheet1.ChartObjects.Delete
Set Rng = [F1:M21] '圖表資料範圍
Set MoObject = Sheet1.ChartObjects.Add(Rng.Left, Rng.Top, Rng.Width, Rng.Height)
'[F1:M21]上新增圖表
Set Rng = [b2:b21].Resize(, 3) '設定範圍
'** 請在 [A2:A21]填上日期或數字 : 作為X座標的數值
MoObject.Chart.SetSourceData Rng '指定圖表資料範圍
Set MoChart = MoObject.Chart
With MoChart
Q(1) = Split(.SeriesCollection(3).Formula, ",")(2) '資料列的儲存格位址
Q(2) = Split(.SeriesCollection(1).Formula, ",")(2)
.SeriesCollection(1).Values = Range(Q(1)) '指定到儲存格
.SeriesCollection(3).Values = Range(Q(2)) '可在儲存格上變動數值
'******************************************************
Stop
Q(1) = .SeriesCollection(3).Values '資料列的數值
Q(2) = .SeriesCollection(1).Values
.SeriesCollection(1).Values = Q(1) '改變數值
.SeriesCollection(3).Values = Q(2) '可在資料列變動數值
End With
End Sub

複製代碼