+ Reply to Thread
Results 1 to 9 of 9

Help making scatter with stright lines end point at X before line end

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Question Help making scatter with stright lines end point at X before line end

    Chart data:

    ....................Point Blank..........Optimal.................Falloff...................2xFalloff
    (X)Range Km.......0......................55.......................93.........................131
    (Y)% Chance......0.723913238......0.723913238........0.361956619............0

    Ok so i will always have a flat line and from optimal to 2xFalloff but there is just a point in the middle called Falloff marking out the half chance.
    Now what i want to do is have an x value that no matter what the chart just stops graphing that one line at X because the data above is just one of 4 lines in the graph

    the graph has to keep the y range of 0%-100% and an X range of 0km-249km
    so I'm really just trying to end each individual lines X value at a certain point before 2xfalloff
    will i have to make a formula to calculate where in the line it would be and have a check that checks to see if it would even be in the line?

    For Example:
    to the graph above i would like to have a forumla so that if i enter 97.75km in a box it ends the cirten line there that would be a little past falloff (the half way point)
    The chart type is Scatter with straight lines
    Last edited by Perdurable; 09-20-2013 at 12:52 PM.

  2. #2
    Registered User
    Join Date
    01-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help making scatter with stright lines end point at X before line end

    anyone??? =(

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

    Re: Help making scatter with stright lines end point at X before line end

    I would imagine most don't understand what you are asking, I don't.

    maybe you could post example workbook illustrating what you are expecting.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help making scatter with stright lines end point at X before line end

    i dont know how else to explain it without showing haha
    so here it is basicly the bottem number in yellow for each ship is the number i am talking about
    i want the line on the graph for that ship to stop at that number because that is the ships targeting range and you cant shoot further then you can target
    Attached Files Attached Files

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

    Re: Help making scatter with stright lines end point at X before line end

    Still not sure I understand.

    I've inserted a new column to calculate value between points.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help making scatter with stright lines end point at X before line end

    no thats nothing close but thankyou nice try haha
    i guess more background would help
    each line represents a ship
    each ship has a different jam strength which is the Y value in %
    each ship has a jamming optimal, falloff, and 2xfall off
    which is basically
    point blank-Optimal=best jam chance
    fall off range=50% jam strength
    2xFall off range=0% chance
    but each ship has a max range it can Lock onto another ship sooo at that max targeting range is where each line needs to stop but it needs to be changeable so that the user can change that range

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

    Re: Help making scatter with stright lines end point at X before line end

    nope, don't understand and your explanation is not making it any clearer.

    Maybe somebody can dechiper what it is you need.

  8. #8
    Registered User
    Join Date
    01-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help making scatter with stright lines end point at X before line end

    haha ok soo i can make it more basic =)
    line is on graph from point A to point B
    how to i enter a number to stop the line befor it gets to point B without changing point B

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

    Re: Help making scatter with stright lines end point at X before line end

    you can't do that. You have to change point B to be the new terminating value, what ever that is.

    You can have original point B displayed in the table just don't give it a Y value and the line will not be drawn

+ 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. Straight Vertical and Horizontal line through a single scatter point.
    By jhall488 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-10-2012, 10:06 AM
  2. Replies: 2
    Last Post: 06-19-2012, 06:50 PM
  3. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  4. Replies: 2
    Last Post: 09-01-2010, 10:22 AM
  5. [SOLVED] I need more general XY point to point plotting than XY scatter in
    By spazminator in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 12-19-2005, 01:10 PM

Tags for this Thread

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