Formulas/macros for creating a sociogram in excel

[ajriddin]

Hi there.

I am wanting to create a sociogram for a school, using Excel. I have got the basic data entry setup, but I have no idea how to transfer the raw data into a sociogram.

I have been able to find some templates available for purchase, but i like the challenge of being able to create one myself.

Any thoughts or suggestions on how this can be done?

 

[RobertSF]

I didn't know what a sociogram was, and when I found out, I thought to myself, "Hell, no, I'm not doing this in Excel!" So hats off for undertaking the challenge. I personally have no clue, but have you seen this page. The author seems to have some free tools especially for this. http://users.sussex.ac.uk/~robinb/socio3.html

 

[ajriddin]

Hehehe thanks for confirming that I'm crazy ??.

I have seen the link, it is really useful, but because the files are read-only, I can't customise the sociogram to my needs.

 

[RobertSF]

I just didn't find much on sociograms. Considered figuring out how to break the passwords in those files.

What you're trying to do is not crazy, but I think it's hard!