I was using Microsoft Paint to make a hierarchy chart, but realized that it is no good as you cannot easily modify text and shapes once you click away from them.
So I tried libre/open office and a bunch of other tools but none of them could do what I want. So instead of wasting time I just made a text document which used strings of text, they were separated horizontally by '>' characters and are separated vertically by line breaks.
So it is sort of a lattice. I have managed to convert this into an excel spreadsheet where each cell contains a single string.
However I am not sure how to convert the text document or excel document into a hierarchy chart. Since there is so many strings, manually copying and pasting them all into their own textboxes is not an option I wanna go for right away.
An example of what I have and what I need:
string1 > string2 > string3 > string4 > string5 string6 > string7 > string8 > string9 string10 > string11 > string12 > string13 > string14 string15 > string16 > string17 > string18 > string19 > string20
Converted To This:
I have tried ms Excel smartart, and 'link data to shapes' in MS visio but all smartart templates limit the number of shapes, and visio can only do one column and you cannot simple click on the data shape to edit the text, a data shape is unlike a textbox.
Is there a way to automatically convert this?