network diagram like view

[Ranjith M]

Hi ,

Im planning to do a network diagram based view of my boxes with naming in excel VBA to have a hierachy like view just mentioned below ,

This is the format i have to idenfify the parent box of a child and its own other child boxes,

3404-3479-1681-1680-1679-1684-1678--------------

3404-3479-1681-1680-1679----------------

3404-3479-1681-1680-----------------

3404-3479-1681------------------

3404-3479-1681-1680-1679-1684---------------

3404-2471-------------------

3404--------------------

i need the output like a network diagram just like this



Above shows a excel view with arrow points the hierachy view , can some one help me to achive this im struggling like anything to prepare this.

 

[vletm]

Ranjith M
Is that Your needed output from that data?

 

[Ranjith M]

Vletm , i cant see anything ,
what i posted are the input and output , this is required ,

 

[Ranjith M]

if you have any prefered way of output , your suggestion is welcome , but i want to project it as a network view.

 

[vletm]

Ranjith M
You sent seven lines numbers in a table and
below those,
there are eight boxes and seven blue arrows.
I'm wondering is Your given sample 100% as required?

 

[Ranjith M]

Box and Lines are the same ,

Lines mentioned are like

a-b-c-d-e
a -c
a-d-e

just to draw lines or creating a primary box as "a" followed by its child boxes,

im trying to do with create shape based on number of values ,

draw lines from a to b , if lines already exist then go next ,

 

[vletm]

Ranjith M
... still wondering

 

[Ranjith M]

i dont know why you are wondering , or atleast give me some ideas how can you help with ,

 

[vletm]

Ranjith M
Check Yourself - what have You given and what are 'needed results'. Do those match?
Without clear writings is possible to do something.
You should help Yourself to get something
- I don't need or have time to dig information from You.
If You can do Your needed
with those Your given informations
then You can do 'something' Yourself.

 

[Ranjith M]

Need a Hirechy like structure thats all i want , im working on Power BI , even those was not helpful.

 

[vletm]

Ranjith M
From Your original...
If You need from this

something like this

it's not clear.
Seems that only thing which is clear ... is that You need or want something.
Especially, after You now wrote 'even those was not helpful.'
For me, that means ... You wanted that someone else would use his/her own time for something 'not helpful'.
That's not so positive.