Hi,
I need to do a graph with 3 points, avg, avg+x and avg-x values. Plus two horizontal lines for Min and Max limit values.
I picked xlXYScatter for the type of graph, and I have 5 .NewSeries()
I can draw the 2 limit lines, but when I try to do the 3 points, for each point I end up with two markers!!
my code for the three points is below:

Set avg = cht.SeriesCollection.NewSeries()
Set avgplus = cht.SeriesCollection.NewSeries()
Set avgminus = cht.SeriesCollection.NewSeries()

With avg
.Name = "avg"
.XValues = Array(5, 0)
.Values = Array(25, 5)
.MarkerStyle = xlMarkerStyleX
End With

With avgplus
.Name = "Avg+"
.XValues = Array(5, 0)
.Values = Array(27, 5)
.MarkerStyle = xlMarkerStyleCircle
End With

With avgminus
.Name = "Avg-"
.XValues = Array(5, 0)
.Values = Array(20, 5)
.MarkerStyle = xlMarkerStyleTriangle
End With

I need the three markers on one X value, but different Y values..
I picked 5, since I dont know how to assign a range to the X axis, since I only want to show 3 points vertically!!
Also, how can I change the Markerstyle to be larger or bold??

any help is appreciated.. this is the first time I am working with VBA graphing..so sorry for my ignorance

thank you,
Karen16