Automatic Organization Chart Maker – Basic Version
Create Org Charts in Excel easily! Automated spreadsheet template for business people who don’t want to waste time on creating org charts.
Payments are processed by our partner company Paddle.com
For all types and scales of organizations, it is indispensable to illustrate the reporting lines. Especially, at growing small and medium scale organizations having max. 40 employees, keeping organizational schemes up to date may become a puzzling situation. Because, in case of each organizational change, you have to deal with boxes, connections, levels and so on. We have built this Excel Organization Chart Maker to ease this process.
Automatic Organizational Chart Maker – Basic Version provides generating an organizational chart for small organizations in JUST 2 STEPS:
- Put employees, their roles and who reports to whom in Excel
- Click the button!
It basically works like this:
Let’s look closer to the sections:
In Dashboard you will simply fill the blank fields with your org structure. Once you type in the names, you will be able to select “Reports to” people from the drop-down.
Please note that there should be one empty cell at “Reports to” column that will be the head of organization. Because in relational database, the template is designed to display one-to-many relationships in the organogram.
The another point you need to be careful, if there are more than one person with the same name, put a little sign like dots, commas etc. You cannot use duplicate names.
Thankfully, if there is a problem with your Org Structure table, message will appear in the Message Box. So you will be able to figure out the problem and create your chart after fixing the issue.
The last section of Dashboard is the Org Box Format. You can put the format (colors, lines) you would like to see here, so whatever you apply there, will be transferred to the family tree automatically.
After apply all procedures above, you can create a diagram for your organization and Export to PDF with from the button on the page.
Need to increase the box size? You can arrange the width or height of the cells to increase their size. After you unprotect your sheet (How can I unlock the sheets? What is the password?) and make the headings visible (I can’t see column headings. How to display them?) you can easily adjust the column and the row structure of the Chart!
Hope this helps!
WHAT DOES AUTOMATIC ORGANIZATION CHART MAKER OFFER?
1. You Save Money
Someka Auto Org Chart Generator is a cheaper option compared to the other organization chart generator tools.
2. You Save Time
This tool provides you to keep your reporting line data and prepare your organization chart, both in Excel. No need to deal with data transfer..
3. It’s User Friendly
If you don’t like the order and layout, just edit your employee table and re-create the chart again. You can also change the box colors. Moreover, Someka Auto Org Chart Generator warns you about possible errors like illogical reporting lines.
Automatic Organization Chart Maker – Basic Version Features:
- Recommended for small organizations which have 30 – 40 employees max (For larger organizations, please check: Someka Auto Org Chart – Advanced Version)
- Organizational Chart Template in Excel
- Clear on sheet instructions (with turn on/off function)
- Works on both Windows and Mac
- Compatible with Excel 2007 and later versions.
- No installation needed. Ready to use.
- Includes VBA code and macros (don’t forget to enable macros after you get it)
- Easy to use and nice design
- Box design can be changeable
- Export to PDF feature
- Print Ready
Someka Organizational Chart Generators Comparison
Links to Versions: