Stakeholder/Influence Map using EXcel

[asolanki]

Hi,

Just wondering if this can be done using excel

I have been asked to look into doing the following

Create a SpreadSheet that lists
Stakeholder Name, ID, Location,departments, Business Partner..etc

For each of these stakeholders the Business Partner needs to Grade the following :
Frequency of Meetings - 1 to 4
Meeting Direction - 1-4
Quality/Maturity - 1-4
etc

Each range 1-4 has its own meaning

Now here is the part i need to know if can be done

Can we select a "Business Partner" and see visually who is connected to the "Business Partner" and with that have the 3 range questions visually displayed by different line thicknesses dependent of the 1-4 choice (very similar to a Sphere of influence)

So quickly we can see that Business Partner "X" has a relationship with Stakeholder "Y "and the Frequency is a "3"- Meeting Direct is a "3" and Quality is a "2"( these represented by different colors and line thinkness to determine the value)
We should also be able to see all the connections to that stakeholder from other business partners if applicable.

I need the ability to choose individually each BP and a Whole view too

any ideas how this can be acheived

Thanks in advance
Ash