the problem is that each series has it's own X's, so if one series has for
example X's = (10, 20, 30) and the other X's (15, 25, 35) i dont know the
matching Y's for cases where the points don't intersect. i need the chart to
calculate the average value between the lines, not the points. I hope i'm
understood now...

thanks

"Barb R." wrote:

I assume that your data for the XY scatter is in this format;

X value Y1 Y2 Y3 Y4 Y5 ... Y10


After the last column of Y values, enter the equation for AVERAGE

Copy that series and paste it onto the original chart. Ensure that the
range of Y values for the Average is consistent with the range for X values.

"Yaniv" wrote:

Hi,

I have an XY line scatter chart with 10 series and i'd like to add a series
which present the average scatter line of these 10 series. the number of
points in each series is different, but the size of the series line is the
same since the X values have the same range.

1. is it possible to acheive such graph?
2. how do i do that?

thanks