- 帖子
- 2035
- 主題
- 24
- 精華
- 0
- 積分
- 2031
- 點名
- 0
- 作業系統
- Win7
- 軟體版本
- Office2010
- 閱讀權限
- 100
- 性別
- 男
- 註冊時間
- 2012-3-22
- 最後登錄
- 2024-2-1
|
19#
發表於 2013-6-11 12:22
| 只看該作者
回復 18# lin_6219
這我倒是沒去留意,為什麼會不同,
我也不清楚。乾脆附上程式碼讓你核對:- Sub Test()
- Dim nRow As Integer, ChtObj As ChartObject
- Dim i As Integer, j As Integer, chartname As String
- Dim myMax, myMin, GapNr As Integer
-
- On Error Resume Next
-
- With Worksheets("主畫面")
- .ChartObjects.Delete
- .Select
- nRow = Worksheets("繪圖資料").Range("A65536").End(xlUp).Row
- Set ChtObj = Worksheets("主畫面").ChartObjects.Add(1, 1, 450, 250)
-
- With ChtObj.Chart
- ' .SetSourceData Source:=Range("繪圖資料!$A$2:繪圖資料!$A$20, 繪圖資料!$F$2:繪圖資料!$F$20")
- .SetSourceData Source:=Range("繪圖資料!$A$2:繪圖資料!$A$" & CStr(nRow) & ", 繪圖資料!$F$2:繪圖資料!$F$" & CStr(nRow))
- .ChartType = xlXYScatterLinesNoMarkers
- .HasTitle = True
- .ChartTitle.Characters.Text = "K線與成交量圖"
-
- With .SeriesCollection(1)
- .Border.ColorIndex = 7
- .Name = "=繪圖資料!$F$1"
- End With
-
- With .Axes(xlCategory) ' X座標軸 (時間軸)
- ' .CategoryType = xlCategoryScale
- ' .TickLabelSpacing = 1 ' 標示間距
- .TickLabels.NumberFormatLocal = "yyyy/m/d"
- .TickLabels.Font.ColorIndex = 5 ' Blue Color
- ' .TickLabels.Orientation = xlTickLabelOrientationUpward
- End With
- End With
- End With
- End Sub
複製代碼 |
|