+ Reply to Thread
Results 1 to 2 of 2

Can I make a graph showing numerous node connections?

  1. #1
    Registered User
    Join Date
    07-03-2012
    Location
    Florence, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Can I make a graph showing numerous node connections?

    Hello,

    I have data of numerous companies which have formed alliances. I'm trying to show a graph of the network diagram of the companies (some are connected to only one partner while others have multiple connections). Is this doable in excel?

    Thanks,
    Steve

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Can I make a graph showing numerous node connections?

    Suggest using a free tool like Gephi. Use Excel to create a csv file with two columns called Source and Target and each following like should contain one pairing. Import into Gephi as an Edge file and select the option to create nodes. A range of different layouts are available on the first tab.

    https://gephi.github.io/
    Martin

+ 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. [SOLVED] Can I make a graph to be a specific size? (actual graph)
    By Jessica in forum Excel General
    Replies: 1
    Last Post: 11-17-2015, 10:43 AM
  2. Graph not showing months ?
    By dougers1 in forum Excel General
    Replies: 1
    Last Post: 11-01-2015, 07:06 AM
  3. How do I make specific calculations based on numerous criteria?
    By Harmse in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2013, 06:29 AM
  4. make numerous workbooks open in excel
    By Tom123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2011, 02:22 PM
  5. Excel 2007 : half graph showing up
    By sfntc in forum Excel General
    Replies: 1
    Last Post: 07-21-2010, 01:39 PM
  6. Excel 2007 : Graph detail not showing
    By keith666 in forum Excel General
    Replies: 2
    Last Post: 04-22-2010, 10:47 AM
  7. [SOLVED] to stop zero from showing on graph
    By natash@ in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-18-2005, 03:07 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