Formula for a straight line on a graph.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I make a scatter plot graph with a category x-axis? 0
Plotting a straight line 3
Creating a Line graph 6
Combining a 2-D column graph and a 2-D line graph on the same char 3
How do I specify X,Y axis and Series values in a line graph? 5
Impossible? Not plotting NA()s 2
Co-ordinates plotting on Graph //sk 1
today line on graph 1

Top