I have a scatter graph which works fine with vba. And I managed to change the colour in the middle of the marker but the border is another colour and so the marker is now two colours. I have the following part of the code:
Sub MySummaryGraph(i As Long, cht As Chart)
With cht
With .SeriesCollection.NewSeries
.Name = ActiveSheet.Cells(i, "HO")
.Values = ActiveSheet.Cells(i, "HN")
.XValues = ActiveSheet.Cells(i, "HU")
.Format.Fill.ForeColor.RGB = RGB(255, 0, 0)
End With
I want to add the code so the border of the marker is also red. And also, I want to add a label which is based on the series name. As I can only seem to label it based on x axis values. If I could keep the same code but just start the next line with .format.border etc - that would be great
Thanks
Sub MySummaryGraph(i As Long, cht As Chart)
With cht
With .SeriesCollection.NewSeries
.Name = ActiveSheet.Cells(i, "HO")
.Values = ActiveSheet.Cells(i, "HN")
.XValues = ActiveSheet.Cells(i, "HU")
.Format.Fill.ForeColor.RGB = RGB(255, 0, 0)
End With
I want to add the code so the border of the marker is also red. And also, I want to add a label which is based on the series name. As I can only seem to label it based on x axis values. If I could keep the same code but just start the next line with .format.border etc - that would be great
Thanks