VB操作Excel繪制圖表,當N=5時,圖表橫坐標為5個值,當N=i時,圖表橫坐標為i個值,橫坐標單元格選擇怎么寫Char.FullSeriesCollection(i).XValues = "sheet(1)!$B$6:$F$6",請各位前輩指教!
uj5u.com熱心網友回復:
Char.FullSeriesCollection(i).XValues = "sheet(1)!$B$6:$" & chr(65+N) & "$6"
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/93862.html
上一篇:VB把X軸的時間改間隔長一點
