Worf

Organization chart with VBA – Part 3

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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.

1687995663551.png
 
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 :)
 

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top