|
以下のようにやってみたんですがPlotBy_:=で名前つき引数がみつかりませんと
エラーがでます。
Charts.Add
ActiveChart.ChartType = xlXYScatter
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:A1200"), PlotBy_:=xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "ハッシュが満杯になるデータの個数"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "頻度"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "個数"
End With
ActiveChart.PlotArea.Select
Selection.Left = 17
Selection.Top = 16
ActiveChart.ChartArea.Select
ActiveSheet.Shapes("グラフ 7").IncrementLeft -68.25
ActiveSheet.Shapes("グラフ 7").IncrementTop -77.25
ActiveSheet.Shapes("グラフ 7").ScaleWidth 1.41,msoFalse,msoScaleFromTopLeft
ActiveSheet.Shapes("グラフ 7").ScaleHeight 1.72, msoFalse, msoScaleFromTopLeft
|
|