excel js addin XYScatter datalabels

Antonov, Viktor 20 Reputation points
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
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

    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.
    User's image

  2. Nobuko Ichimaru 316 Reputation points

    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