excel js addin XYScatter datalabels

Antonov, Viktor 20 Reputation points
2023-03-14T22:25:20.66+00:00
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,703 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,430 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
862 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Nobuko Ichimaru 316 Reputation points
    2023-03-26T11:44:59.4533333+00:00

    hi! @Antonov, Viktor

    sorry, not codes solution,

    some graphs from a table in your excel sample sheet.
    You can download and edit.

    It hope if I could help you even just a little.
    https://1drv.ms/x/s!At950JyIeN6wgeoNVJ7JPhlqx2sWhw?e=N3jepo
    User's image


  2. Nobuko Ichimaru 316 Reputation points
    2023-03-30T14:36:35.3933333+00:00

    thanks, your responce.
    Just a little bit, I was able to create a chart in code.

    It may be far from your hope.

    Sub zu()
    
        ActiveSheet.Shapes.AddChart2.Select 'グラフを挿入
        ActiveChart.ChartType = xlXYScatter '散布図
        ActiveChart.SetSourceData Range("A1").CurrentRegion '参照範囲を設定
        
    End Sub
    
    
    Sub graph()
        
        Range("A1").Select '元データを選択
        ActiveSheet.Shapes.AddChart2.Select 'グラフを挿入
        ActiveChart.ChartType = xlLine '折れ線
        
    End Sub
    
    

    User's image