Line in excel chart to intersect with trendlines and drop down

[jondavis1987]

I have a scatter chart with a secondary axis with exponential trendlines. It draws from three columns. Column A is the X axis. Column B is on the secondary axis in reverse order. Column C is on the main Y axis. There will be a dynamic target for each trendline. I was wondering if there is a way to make a dynamic series that will meet the trendlines and then drop? for instance the trendline for column B where it hits 12.5 I'd like it to have a line that goes at 12.5 from the secondary axis, intersects with the trendline, and then drops straight down. For the Column C trendline i'd like the same thing except that line be at 80. But these numbers can change.

 

[NdNoviceHlp]

Hi Jondavis1987. I'm not exactly sure that I understand the exact outcome you want but it sounds like adding "dummy" series' to your chart is what you're after. See this site for all things chart (and more). HTH. Dave

Charting in Microsoft Excel

Index of the Microsoft Excel Charting directory of the Peltier Tech web site.

peltiertech.com

 

[jondavis1987]

I got this to work. Took some doing. Putting the answer incase anyone needs this. I changed it to a linear trendline, calculated the trendline doing =(Maximum point-Intercept(Y Values, X Values))/Slope(Y Values, X Values). Plotted that point as it's own point. Then added an error bar with no end caps and a 0 positive value. Then i made a dummy series with the point i just plotted and another point with the same value and with a zero for the for the y axis creating a line up to the point where the error bar was.

 

[NdNoviceHlp]

That seems like quite an ingenious solution. Thanks for posting your outcome. Dave