0

I have data about the relationship between each element in a set as seen in the table below:

table

Is there a way to create a relationship graph from this data as shown in the below illustration?

relationship graph

2
  • 2
    No there is not any graph that looks even close to what you are seeking. There may be something in PowerBI, and you can download the desktop version for free.
    – PeterH
    Apr 3, 2019 at 11:42
  • For future viewers, this tool is useful: eiranling.github.io/json-to-graph
    – Ollie
    May 18, 2019 at 8:49

1 Answer 1

1

Excel doesn't have a native capability for that type of chart. However, depending on how much work you want to put in, an XY/Scatter chart can display almost anything-it's simply a series of connected points (series). The work is usually in making a sensible data layout is consistent for data entry.

Another Excel approach would be to use one of Mike Bostock's solutions. He's a wizard for visualizations and if you're comfortable with VBA, you can probably hack something together (I use his sankey diagram solution). Somewhere on his site he has a demo Excel workbook with several of his visualizations to play with. You can also find a D3 example on StackOverflow. And if you want to support D3 integration into Excel, please vote here.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .