Plotting a straight line

  • Thread starter Thread starter OscarC
  • Start date Start date
O

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
 
OscarC said:
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.
Click to expand...

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