O
OscarC
Hello,
I have some spreadsheets with dynamic charts - ie as data is added to
the worksheet, the chart automatically updates.
The charts are line graphs - date on the x axis, data on the y axis.
The dynamic formulas I use for the x axis (readdate) is
=OFFSET('BH33'!$A$8,0,0,COUNTA('BH33'!$A:$A)-7,1)
and the forumula for the y axis range is (EC)
=OFFSET('BH33'!$H$8,0,0,COUNTA('BH33'!$H:$H)-6,1)
I want to add a fixed straight line to the graph, say at the value
"2".
I looked on the http://www.tushar-mehta.com/ website, and found a
formula for plotting the meanline:
=AVERAGE(OFFSET('BH33'!EC,0,0))*ROW(EC)/ROW(EC)
how do I adapt this so that it will only plot a fixed value (eg 2)?
thanks in advance
Michael
I have some spreadsheets with dynamic charts - ie as data is added to
the worksheet, the chart automatically updates.
The charts are line graphs - date on the x axis, data on the y axis.
The dynamic formulas I use for the x axis (readdate) is
=OFFSET('BH33'!$A$8,0,0,COUNTA('BH33'!$A:$A)-7,1)
and the forumula for the y axis range is (EC)
=OFFSET('BH33'!$H$8,0,0,COUNTA('BH33'!$H:$H)-6,1)
I want to add a fixed straight line to the graph, say at the value
"2".
I looked on the http://www.tushar-mehta.com/ website, and found a
formula for plotting the meanline:
=AVERAGE(OFFSET('BH33'!EC,0,0))*ROW(EC)/ROW(EC)
how do I adapt this so that it will only plot a fixed value (eg 2)?
thanks in advance
Michael