Graph line graphs where X & Y values meet
 

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

Graph line graphs where X & Y values meet
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
ups.com...
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