Results 1 to 1 of 1
Thread: Excel VBA - ?
Hybrid View
-
26th October 2017 13:06 #1
Excel VBA - ?
!
, VBA. . , . , , , ( C9 *, * ).
Googl, , , . , :
, .Code:Dim ch As Shape lastrow = ActiveSheet.Cells(ActiveSheet.Rows.Count, "B").End(xlUp).Row ActiveSheet.Range("B9:C" & lastrow).Select ActiveSheet.Shapes.AddChart.Select Set ch = ActiveSheet.Shapes(1) ch.Name = "Security 1" ActiveChart.ChartType = xlLine ActiveChart.SetSourceData Source:=Range("Model!$B$9:$C$" & lastrow)
, , e :

: , . - ( , , ) ?
, ( )?
!Code:ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).Name = "= !$B$8" ActiveChart.SeriesCollection(1).Values = ******* ActiveChart.SeriesCollection(2).Name = "= !$E$8" ActiveChart.SeriesCollection(2).Values = ******* ActiveChart.SeriesCollection(2).XValues = *******
EDIT: , .Last edited by te0o; 26th October 2017 at 18:25.
Dell XPS 13 9300 | i7-1065G7 | 16GB 3733MHz LPDDR4x | 512GB M.2 PCIe NVMe SSD




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in