average line needed from one single cell

  • Thread starter Thread starter Norbert
  • Start date Start date
N

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
 
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
 
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
 
Back
Top