+ Reply to Thread
Results 1 to 6 of 6

I want to show the intersection point in the chart....

  1. #1
    Registered User
    Join Date
    06-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    70

    I want to show the intersection point in the chart....

    Hi...

    I am doing break even analysis in excel and i create a line chart on the basis of data. So now i want to show the intersection point in that chart with label. So any one can help me in this.

    Please find the attachment....

    Book1.xlsx


    Thanks in advance

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: I want to show the intersection point in the chart....

    Here is one solution. To do this requires a little math. You have to define both the x and y values for the intersection point, then plot that point as an additional data series. You can see how I've done it in your example. I used a little different calculation for the y value but got the same answer as you.

    Then you have to change the plot from a Line Chart to a Scatter Chart.

    (I do not know why the legend does not match the formatting of the intersection point as plotted.)
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: I want to show the intersection point in the chart....

    @ 6StringJazzer, legend does reflect the line/marker format used.

    The difference is caused by 2 two things. First your series only has 1 point so the Line is not displayed. Second your legend entry is small enough for the hollow data marker to appear filled due to thickness of line.

    To get an exact match set the Line to None.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: I want to show the intersection point in the chart....

    That certainly--what is it they say over there--works a treat! Thanks Andy.

  5. #5
    Registered User
    Join Date
    02-07-2017
    Location
    Osijek, Croatia
    MS-Off Ver
    2010
    Posts
    3

    Re: I want to show the intersection point in the chart....

    Your solution is nice, but in my opinion maybe a little bit unpractical because it can be used only for linear graphs.
    I read about the idea of trying to solve it with the INTERSECT and SLOPE function, but I believe they are also just for linear graph usage.

    P.S. excuse me for my bad English, this was just my first reply on any forum at all

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: I want to show the intersection point in the chart....

    Quote Originally Posted by matheo0602 View Post
    Your solution is nice, but in my opinion maybe a little bit unpractical because it can be used only for linear graphs.
    I read about the idea of trying to solve it with the INTERSECT and SLOPE function, but I believe they are also just for linear graph usage.

    P.S. excuse me for my bad English, this was just my first reply on any forum at all
    Thanks for your contribution (your English is fine!). Because the question was about a linear graph, the solution is appropriate. If you have a similar problem but with nonlinear data, please feel free to start a new thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Show specific point in line chart
    By gnoke in forum Excel General
    Replies: 1
    Last Post: 11-16-2011, 04:33 AM
  2. Replies: 1
    Last Post: 07-30-2009, 10:12 AM
  3. Marking point of intersection on double y axis chart?
    By TheBigLoofah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2006, 07:10 PM
  4. Chart point colours to show time trend
    By AndyE in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-13-2005, 05:06 AM
  5. [SOLVED] How do I show the maximum point on a scatterplot chart?
    By Chief in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-08-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1