Sub grafiekbewerken()
Charts("O2 (ppm) vs Time (days) graphic").Select
With ActiveChart
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Time (Days)"
.Axes(xlCategory, xlPrimary).AxisTitle.Font.Name = "Arial"
.Axes(xlCategory, xlPrimary).AxisTitle.Font.FontStyle = "Vet"
.Axes(xlCategory, xlPrimary).AxisTitle.Font.Size = 16
.Axes(xlCategory, xlPrimary).TickLabels.Font.Size = 16
.Axes(xlCategory, xlPrimary).TickLabels.Font.Name = "ariel"
.Axes(xlCategory, xlPrimary).TickLabels.Font.FontStyle = "vet"
.Axes(xlCategory, xlPrimary).Border.Weight = xlThick
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "O2 (ppm)"
.Axes(xlValue, xlPrimary).AxisTitle.Font.Name = "Ariel"
.Axes(xlValue, xlPrimary).AxisTitle.Font.FontStyle = "Vet"
.Axes(xlValue, xlPrimary).AxisTitle.Font.Size = 16
.Axes(xlValue, xlPrimary).Border.Weight = xlThick
.Axes(xlValue, xlPrimary).TickLabels.Font.Size = 16
.Axes(xlValue, xlPrimary).TickLabels.Font.Name = "ariel"
.Axes(xlValue, xlPrimary).TickLabels.Font.FontStyle = "vet"
For d = 1 To .SeriesCollection.Count
.SeriesCollection(d).Border.Weight = xlThick
Next
End With
With ActiveChart.Legend
For i = 1 To .LegendEntries.Count
.LegendEntries(i).Font.Name = "Arial"
.LegendEntries(i).Font.FontStyle = "Vet"
Next
End With
End Sub