Chart Average Line

[Tikey]

I have a spreadsheet with a number of cells whose data is used for one line on the chart, I would also like to include an average line on the chart. Whilst I appreciate I can create a 'Dummy' set of cells of the average value to create the average line, but I wondered whether there is a way of creating the line just from a single cell containing the average value.

Thanks

 

[BSALV]

easiest way, add an extra column with your average

james.xlsb
	A	B	C	D	E	F	G	H	I	J	K
1	item	value	avg
2	a	5	8,2
3	b	10	8,2
4	c	10	8,2
5	d	5	8,2
6	e	9	8,2
7	f	8	8,2
8	g	9	8,2
9	h	10	8,2
10	i	9	8,2
11	j	7	8,2
12
13
14
15
16
17
Blad3

Cell Formulas
Range	Formula
B2:B11	B2	=RANDBETWEEN(5,10)
C2	C2	=AVERAGE(B2:B11)
C3:C11	C3	=+C2

 

[Tikey]

I was hoping I could avoid adding extra columns of data, but from your reply I guess not.

Thanks for your reply.