Re: [VBA ] excel以變數畫圖表的問題

看板Visual_Basic作者loveholic39 ( )時間15年前 (2011/03/15 16:03)推噓0(0推 0噓 0→)

留言0則, 0人參與討論串2/2 (看更多)

※ 引述《loveholic39 ( )》之銘言： : 我想以L2 , L3 兩個儲存格當圖表範圍的變數 : Dim aaa As String : aaa = [L2] (L2儲存格文字為"B10") : Dim aab As String : aab = [L3] (L3儲存格文字為"B20") : ActiveSheet.ChartObjects("圖表 21").Activate : ActiveChart.ChartArea.Select : ActiveChart.SeriesCollection(1).Values = "=Sheet1!aaa:Sheet1!aab" : ActiveChart.SeriesCollection(1).Name = "=Sheet1!R1C2" : Windows("紀錄表33.xls").SmallScroll Down:=12 : 偵測到錯誤要怎麼改才對呢? 自問自答 firrow = [L2] (*L2 = 10) lasrow = [L3] (*L3 = 20) ActiveSheet.ChartObjects("圖表 21").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = ActiveSheet.Range(ActiveSheet.Cells(firrow, 2), ActiveSheet.Cells(lasrow, 2)) ActiveChart.SeriesCollection(1).Values = ActiveSheet.Range(ActiveSheet.Cells(firrow, 4), ActiveSheet.Cells(lasrow, 4)) -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 61.231.74.126

‣ 返回看板[ Visual_Basic ] 程設

‣ 更多 loveholic39 的文章

文章代碼(AID): #1DVnrfPO (Visual_Basic)