Hello,
Please refer to the attached chart.
How do I stretch the PINK line so that it can plot the value contained in cell D2 over the entire period.
What I am trying to do is what a guy was asking in the forum. However, the solution posted could not work.
Thanks much.
The question and solution from excel forum
Constant horizontal line on a chart (based on a single value)
Posted by Skewer on July 18, 2001 11:22 AM
Image the scene, you want a graph showing stuff but there is an ideal value or range of values (as in cost, weight, etc).
How can I get a single value (already calculated elsewhere) or values to generate horizontal lines so at a glance the approach towards (or fluctuation between) certain values is visible?
I could just draw an autoshape over the graph I guess but then how could I get that to move around?! Surely there's a chart method that doesn't involve a hidden row(s) containing solely absolute references to this value in its calculated location?
Cheers,
SQR
Re: Constant horizontal line on a chart (based on a single value)
Posted by Mark W. on July 18, 2001 11:55 AM
Let's assume that your desired Y-intercept value
is in cell Sheet1!$A$1. First, create a defined
name called Sheet1!Y_Intercept_Value with a
reference of ={1,1}*Sheet1!$A$1. Select your
chart area and on the formula bar enter the formula,
=SERIES(,,Sheet1!Y_Intercept_Value,1). Y=A1 should
now be plotted on your chart!
Bookmarks