Graph line graphs where X & Y values meet

[conorfinnegan]

Thanks in advance to anyone that can help me or tell me that this
isn't possible.

I have a chart that has 3 series in it. It is a reach and frequency
distribution based on client spending. It draws the Line Graphs
perfectly. I was wondering though that if a user could input their
desired spend, Excel could then draw another line graph (like a 90
degree angle) to show where they would fall on the graph. Is this
even possible? Are there better add-ons or programs for Excel that
can do what I want? I mean, I can manually draw the meeting point
lines but I would rather have something automatically add it since I
will be generation numerous graphs everyday.

Please let me know or if you need further clarification, let me know
that too.

Thanks again.

Conor Finnegan

 

[Jon Peltier]

You haven't defined any of your terms, nor explained what series plots which
values against which axes, nor provided any sample data.

- Jon