Share via

excel js addin XYScatter datalabels

Antonov, Viktor 20 Reputation points
2023-03-14T22:25:20.66+00:00

can anyone help me? =(

https://stackoverflow.com/questions/75577766/excel-js-addin-xyscatter-datalabels

https://learn.microsoft.com/en-us/answers/questions/1184442/excel-js-addin-xyscatter-datalabels?source=docs

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.
4,364 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
942 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  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