create a diagram with a table of data

[Tetonne]

Hello
i'm looking for fexcel file to draw a diagram (processs or decision tree) from date in a table with excel. Is-it possible? can someone share this?
regards
thanks a lot for your help?

 

[Peter Bartholomew]

There is an add-in that is available from Office 365 that links to Visio to create a few diagram types from a Table.
https://support.office.com/en-us/ar...r-add-in-bee3b5aa-aaaf-4401-acc6-276b711c763c

Alternatively, something that is possible using VBA, is to reverse the process and draw the diagram manually using Shapes ((and connectors) and then use the Shape properties to recreate the table. To create the diagram from the table using VBA would get you into heavy programming when it comes to determining the best layout for elements of the diagram.

 

[Tetonne]

There is an add-in that is available from Office 365 that links to Visio to create a few diagram types from a Table.
https://support.office.com/en-us/ar...r-add-in-bee3b5aa-aaaf-4401-acc6-276b711c763c

thanks for this answer, picture are from this add ins but i do not have visio :-(, it cost a lot lol

Alternatively, something that is possible using VBA, is to reverse the process and draw the diagram manually using Shapes ((and connectors) and then use the Shape properties to recreate the table. To create the diagram from the table using VBA would get you into heavy programming when it comes to determining the best layout for elements of the diagram.

ok :-( if someone have a solution even less powerful, i'm still interested

 

[Peter Bartholomew]

:-(, it cost a lot lol

But probably not as much as custom code development. I once read a set of diagrams such as that below and produced a file.




All I managed for output was a tiny fragment of the diagram that I could navigate by clicking boxes.

It took weeks!