Plotting intersection of two values
 

I have data in 2 columns that need to go on the X and Y axes =- example:

X-axis Y-axis
-40.38 -6.57
-41.83 -0.43
-39.80 -0.40
-38.25 -16.11
-36.08 0.72
-34.62 -26.97
-31.28 -48.73
-26.72 -62.68
-25.42 -63.63

How do I plot the intersection of these two values?

Many thanks!
sandy

Plotting intersection of two values
 

Hi,

I have a explanation which may help.
http://www.andypope.info/charts/intersection.htm

Cheers
Andy

Sandy wrote:
I have data in 2 columns that need to go on the X and Y axes =- example:

X-axis Y-axis
-40.38 -6.57
-41.83 -0.43
-39.80 -0.40
-38.25 -16.11
-36.08 0.72
-34.62 -26.97
-31.28 -48.73
-26.72 -62.68
-25.42 -63.63

How do I plot the intersection of these two values?

Many thanks!
sandy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info