More than 1 year has passed since last update.

VBAでグラフ作成　初心者

ExcelVBA

Last updated at 2023-05-14Posted at 2023-05-14



Sub test()

Max = Cells(1, 1).End(xlDown).Row


With ActiveSheet.Shapes.AddChart.Chart
    .ChartType = xlLine
    .SetSourceData Range("A1:D" & Max & "")
    .HasTitle = True       'グラフタイトルの追加
    .ChartTitle.Text = "TEST"
End With

Worksheets("Sheet2").Activate
Worksheets("Sheet2").Range("A1").Activate

End Sub

以下の参考に
これから徐々にレベルアップ

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

VBAでグラフ作成 初心者

VBAでグラフ作成　初心者