SOLVED

Find intesection point of line graph

%3CLINGO-SUB%20id%3D%22lingo-sub-2420786%22%20slang%3D%22en-US%22%3EFind%20intesection%20point%20of%20line%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420786%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Friends%2C%3C%2FP%3E%3CP%3E%26nbsp%3BNeed%20to%20calculate%20the%20intersection%20point%20of%20line%20graph%20and%20want%20to%20create%20a%20vertical%20axis%20passing%20through%20the%20intersection%20point%20of%20the%20line%20graph.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh_32_1-1623042351944.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286738i789D9576B14A9770%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh_32_1-1623042351944.png%22%20alt%3D%22Rajesh_32_1-1623042351944.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2420786%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2421387%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20intesection%20point%20of%20line%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2421387%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072477%22%20target%3D%22_blank%22%3E%40Rajesh_32%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20it%20stands%2C%20it%20just%20looks%20like%20a%20pair%20of%20simultaneous%20equations%20to%20solve.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286801iA4C7760666B9569F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2421435%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20intesection%20point%20of%20line%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2421435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20solution.%20Can%20you%20explain%20me%20how%20the%20chart%20%26amp%3B%20intersection%20point%26nbsp%3B%20arrived%20if%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2422499%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20intesection%20point%20of%20line%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2422499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072477%22%20target%3D%22_blank%22%3E%40Rajesh_32%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wrote%20linear%20equations%20for%20both%20the%20sales%20and%20the%20consumption%3CBR%20%2F%3E%3CSTRONG%3E%3CEM%3Es%3C%2FEM%3E(%3CEM%3Ep%3C%2FEM%3E)%3CEM%3E%20%3D%20s%3C%2FEM%3E%E2%82%80%3CEM%3E%20%2B%20%3C%2FEM%3E(%3CEM%3Es%3C%2FEM%3E%E2%82%81%3CEM%3E-s%3C%2FEM%3E%E2%82%80)%3CEM%3Ep%3C%2FEM%3E%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%3CEM%3Ec%3C%2FEM%3E(%3CEM%3Ep%3C%2FEM%3E)%3CEM%3E%20%3D%20c%3C%2FEM%3E%E2%82%80%3CEM%3E%20%2B%20%3C%2FEM%3E(%3CEM%3Ec%3C%2FEM%3E%E2%82%81%3CEM%3E-c%3C%2FEM%3E%E2%82%80)%3CEM%3Ep%3C%2FEM%3E%3C%2FSTRONG%3E%3CBR%20%2F%3Eand%20set%20them%20equal%20to%20determine%20the%20value%20of%20%3CSTRONG%3E%3CEM%3Ep%3C%2FEM%3E%3C%2FSTRONG%3E%20at%20the%20point%20of%20intersection%2C%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3Ep%20%3D%20%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E(%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3Ec%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%E2%82%80-%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3Es%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%E2%82%80)%20%2F%20(%3C%2FSTRONG%3E%3CSTRONG%3E(%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3Es%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%E2%82%81%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3E-c%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%E2%82%81)-(%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3Es%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%E2%82%80-%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3Ec%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%E2%82%80))%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Friends,

 Need to calculate the intersection point of line graph and want to create a vertical axis passing through the intersection point of the line graph.

Rajesh_32_1-1623042351944.png

 

 

4 Replies
best response confirmed by Rajesh_32 (New Contributor)
Solution

@Rajesh_32 

As it stands, it just looks like a pair of simultaneous equations to solve.

 

image.png

@Peter Bartholomew Thanks for your solution. Can you explain me how the chart & intersection point  arrived if possible.

@Rajesh_32 

I wrote linear equations for both the sales and the consumption
s(p) = s + (s-s₀)p
c(p) = c + (c-c₀)p
and set them equal to determine the value of p at the point of intersection,

p = (c₀-s₀) / ((s-c₁)-(s₀-c₀))

Thank you so much for your knowledge share. Its highly informative.