Plotting a straight line

[OscarC]

Hello,

I have a dynamic line chart which uses the following named ranges:

x axis:

ReadDate =OFFSET(LMP1A!Levels,0,-2)

y axis:

Levels =OFFSET(LMP1A!$C$4,0,0,COUNTA(LMP1A!$C:$C)-1,1)


I would like to add a constant staright line to the chart, ie plotting
a constant value (e.g. 27) for every point plotted on the chart.

I know I could do this by creating another column of data with the
value of 27 all the way down for each corresponding value, but is
there a way of doing this in a formula?

I thought I could do it by typing my constant value (27) in a cell and
naming that as "trigger"

I then created another range called "TriggerLevel" which I thought
would plot a staright line:

TriggerLevel
=(Trigger)+(OFFSET(LMP1A!Levels,0,1))*ROW(Trigger)/ROW(Trigger)

However it does not work. Anyone got any better ideas?


thanks


Michael

 

[dvt]

I have a dynamic line chart which uses the following named ranges: ....
I would like to add a constant staright line to the chart, ie plotting
a constant value (e.g. 27) for every point plotted on the chart.

Have you looked at Tushar Mehta's site? If not, try tushar-mehta.com and
click on Straight Lines on the left side.

Dave
dvt at psu dot edu

 

[Jon Peltier]

Or the 'add a horizontal or vertical line' page on my web site:
http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#AddLine

- Jon

 

[OscarC]

Thanks for the advice guys!

Or the 'add a horizontal or vertical line' page on my web site:
http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#AddLine

- Jon