Graph line graphs where X & Y values meet

  • Thread starter Thread starter conorfinnegan
  • Start date Start date
C

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
 
You haven't defined any of your terms, nor explained what series plots which
values against which axes, nor provided any sample data.

- Jon
 
Back
Top