In , Andy Pope
spake thusly:

Here you go. assumes series values are in C3:C6, which is 4
values. The row numbers raised to the power 0 is 1. So you get
the average 4 times.

=AVERAGE(Sheet1!$C$3:$C$6)*(ROW(Sheet1!$1:$4)^0)

Impressive! Thanks, Andy.

-dman-

================================================== =
Dallman Ross wrote:

Okay, Andy, here's a new challenge: can we add an average line
to a chart without bothering with a dummy column or range
filled with the average?