average line needed from one single cell

[Norbert]

in B3 to M3 (=12cells) I enter data for 12 months
in N3, I calculate the average of the 12months
How will I get an average line in a graph from that single cell N3?
Thanks

 

[Andy Pope]

Hi,

Tushar has an example of using a named range.
http://www.tushar-mehta.com/excel/charts/straight_lines/index.html

Cheers
Andy

 

[Norbert]

Hi Andy,
thanks for that link. I struggled a bit, as my data is columns not in
rows but eventually
I got it right.
Thanks,
Norbert

 

[Jon Peltier]

Sometimes you can simplify your life by using multiple cells, all linked to
the cell with the calculation. Cells are inexpensive, and you can put them
out of the way.

Alternatively you can repeat the same cell in a series formula:
=SERIES(,,(Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8,Sheet1!$C$8),2)

These may not be "elegant" solutions, but they are easy, and for a quick and
dirty look at something, setting up names and applying them to charts seems
like overkill.

- Jon