+ Reply to Thread
Results 1 to 3 of 3

Connecting user-defined points in scatter plot

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    6

    Connecting user-defined points in scatter plot

    Hello all,

    I am trying to create a truss solving program. I would like the user to define the number of nodes in the truss and give coordinates for each node (i.e. node 1, node 2, etc). Then the user will create the truss members by defining their connecting nodes (i.e. member 1 is node 1 to node 2). I would like to create a plot of the truss to show the user what he or she is inputting. Is there a way to define the nodes as coordinates so that I could simply create another series of the nodes. I hope what I am describing is not too confusing. I have attached a small sample in which I want the four nodes to be connected according to the user-defined left and right nodes (i and j joints in spreadsheet).
    Attached Files Attached Files

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

    Re: Connecting user-defined points in scatter plot

    You just need to plot the node pairs. I have set up 16 elements for you, can and simple extend the formula and chart data series.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-01-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Connecting user-defined points in scatter plot

    That is exactly what i wanted. Thank you very much

+ 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. Conditionally formatting the color of the lines connecting two points on a scatter graph
    By AtlasLion21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 11:44 AM
  2. Only plot scatter points that have both an X and a Y value (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2009, 04:23 AM
  3. Excel 2007 : Labelling Data Points on a Scatter Plot
    By SDruley in forum Excel General
    Replies: 3
    Last Post: 06-01-2009, 09:56 AM
  4. [SOLVED] Connecting Points In An XY-Scatter Plot Graph
    By Adam WK in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-09-2006, 02:10 PM
  5. [SOLVED] Scatter plot points x and y coordinates
    By Milo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2005, 07:25 PM

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