I have data about the relationship between each element in a set as seen in the table below:
Is there a way to create a relationship graph from this data as shown in the below illustration?
1 Answer
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.
