Results 1 to 1 of 1

Thread: Excel VBA - ?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Wolfdale te0o's Avatar
    Join Date: Jan:2010
    Location: UK
    Posts: 2,645

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |