excel js addin XYScatter datalabels

Anonymous
2023-03-14T22:25:20.66+00:00
Microsoft 365 and Office | Development | Office JavaScript API
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
{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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.