Organization chart with VBA – Part 3

At cell B30, it should be CHILD5.

Thanks Worf and sorry for that - it was my silly mistake.
Your workfile works great now! thanks again! .


Just one final question.
Which lines of the macro would I need to change/ adjust if my description contains more than 10 characters.
Or is there a way to have the width of the box be conditioned on the max count of characters (max-len?) within the data table (fshap)

I was testing this and the boxes on my chart start overlapping with "desc extra super long"

Here's a screenshot of what my chart looks like with the above.
Once again, thank you so much - this is a really brilliant workbook.

Some new code is required for the horizontal adjustments, I will write it.

I have been busy these days so it may take a while…

Hi Worf,

Thank you so much again for being so generously helpful.
No rush in getting this new code added and I'm sure everyone (including me) following and using your workbook will be looking forward to it.

Thanks again!!!!

I posted a solution:

Thanks Worf for the improved update. Very much appreciated