OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Get all OfficeHelp.Biz TEMPLATES at once!

Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
Macro Microsoft Excel OfficeHelp 19.95 USD

Organization Chart Maker for Microsoft® Excel® - Version 2.10

Tested on Microsoft Excel Versions: 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 2003

(How to Buy)

 
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts. Runs in Excel, no installation required. Really EASY - if you know Excel, you know this!


Tired of manually creating your organization charts? Tired of millions of manual updates? 

If you have Microsoft Excel, you can now generate Organizational Charts, just by entering the hierarchy members and associated data like their name and function. Use different colors and customization options. Import data from external applications like ERP, Accounting or RH packages. Whole or partial hierarchies from the same data.

Based only in EXCEL - No installation or setup required. Just open in Excel and run! 


Really EASY to use - If you know Excel, you know this!

Really easy to use, just fill in the values in the Input Cells (or import them from an external application, like SAP, Oracle, Microsoft Dynamics or any ERP / RH / any management package) and press the "Run" button to create several different styles of Organizational Charts.

The system will generate a new workbook with the resulting Org. Charts (PICs. 2 to 5, 7 and 8). This new workbook HAS NO MACROS on it, just the resulting chart. Change, save and email it as any other regular Microsoft Excel file.

Screen Shot from the Microsoft® Excel Macro File (Click to Enlarge)

PIC. 1 - Screen Shot from the Microsoft Excel Macro File (Click to Enlarge)


MULTIPLE uses. Draw charts for all types of hierarchies!

Much more than Corporate Staff charts. Multiple types of hierarchic charts can be drawn with the same tool, like Staff charts, Shares Ownership, Website Navigation, Portfolios, etc:

Staff Chart (Click to Enlarge)

PIC. 2 -Staff Chart – From the whole company to a single department, including company structure, subordinates and assistants. Can represent special purpose details, like Color Maps / Heat Maps for staff performance (Click to Enlarge). 

Shares Ownership Chart (Click to Enlarge)

PIC. 3 -Shares Ownership – Create charts to illustrate shareholder relationships. Use the fields available to show % owned and other relevant information. Apply color to illustrate variables like control (ownership > 50%) - (Click to Enlarge)

Website Navigation Chart (Click to Enlarge)

PIC. 4 - Website Navigation – Easily and quickly represent your website navigation structure and pages on a simple to understand chart (Click to Enlarge)

Website Navigation Chart (Click to Enlarge)

PIC. 5 - Portfolios – Easily and draw a portfolio of assets – financial investments, real estate, etc. Use colors to represent returns, etc (Click to Enlarge)


IMPORT from external sources. Link to 3rd party software like ERPs, RH suites, line of business, etc!

Easily draw Org. Charts with data from external sources like from ERP or HR management systems like Microsoft Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc.

Create a report on the source software (ex: ERP or RH software) that exports a plain text file with the same columns as the "Organization Chart Members List" and load it into Excel. Colors can be applied by name. Export the color name in text and the Excel macro will apply the correct color based on your definitions.

Data Import Diagram (Click to Enlarge) 
PIC. 6 - Data Import Diagram (Click to Enlarge)


What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (ExOrgChartMaker2.xls).  Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file).  Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. The DEMO version of other products can be also included for evaluation purposes. There is a README.TXT tet file on the ZIP with a full description of its contents.

Based only in EXCEL - No installation or setup required. Just open in Excel and run! 

Try our FREE DEMO

Download and try our FREE DEMO. It works exactly as they Full Version except for these restrictions:

  • None (no restrictions) while using the Original Sample Data as provided by OfficeHelp.Biz:
    • This allows you to freely test the macro functionality, but restricted to our sample data;
    • Original Sample Data can be restored using the "Reset DEMO Data" button on the Input sheet;
        
  • Maximum of 15 nodes if using data different from our own Original Sample Data:
    • Extra nodes on the member list will be ignored;
    • Limit applies to drawing order, not data entry order;

Download your FREE DEMO here! 

Don't wait any more! Create YOUR OWN version of the Organization Chart Maker for Microsoft Excel.

(How to Buy)

Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


ADVANCED CUSTOMIZATION

The Organization Chart Maker for Microsoft Excel  allows for multiple customizations of the final Org. Chart, from simple font and color formatting to chart scope and depth.


TWO types of Org. Charts from the SAME data (member list)

Generate Wide, Narrow or ALL (both in a single run) format Organizational Charts: 

Wide Charts (Click to Enlarge) 
PIC. 7 – Wide Charts - the last level of the chart is drawn with all members split horizontally over the same row. Produces wider (more columns) but shorter (less rows) charts. (Click to Enlarge)

Narrow Charts (Click to Enlarge) 
PIC. 8 - Narrow Charts - the last level of the chart is drawn with all members split vertically on the same column. Produces narrower (less columns) but longer more rows) charts. (Click to Enlarge)


ASSISTANTS Support

Subordinates may be defined as Assistants and drawn on a different position that other direct reports: between the Parent and its direct report Subordinates.

Assistants – assistants may be defined at several places in the organization (Click to Enlarge) 
PIC. 9 - Assistants – assistants may be defined at several places in the organization (Click to Enlarge)


TOTAL / PARTIAL Charts

Charts may have multiple scopes (Whole Company / Department) and depths (All subordinates / Only direct reports and their immediate levels) from the same data (members list).

Define where the Org. Chart will start and how many levels will be included and only that data will be included from 2 simple options near the Run button.

Scope – Define where on the hierarchy your chart starts (Click to Enlarge) Depth – Define how many levels your chat will have (Click to Enlarge)
PIC. 10 - Scope – Define where on the hierarchy your chart starts (Click to Enlarge) PIC. 11 - Depth – Define how many levels your chat will have (Click to Enlarge)

COLOR MAPS - USE COLOR for INFORMATION

Apply colors to each Org. Chart member to communicate highly effective visual information:

  • Employee performance;
  • Portfolio returns;
  • Departments;
  • Web Site page categories;
  • .... any other ...

Color can be applied directly by painting the color cell for each member of by name. The “Organization Chart Maker for Microsoft Excel” will automatically convert the color name into its defined color by using the Colors Text Equivalence table on the CONFIG sheet:

Colors Table - Allow conversion of color labels into colored cells. 
PIC. 12 – Colors Table - Allow conversion of color labels into colored cells.


LOOKs – Fonts, Sizes & Printing

Multiple aesthetics definitions are available on the CONFIG sheet, where it may be defined by example (format a sample cell and its formats will be applied to the output):

  • Fonts for the Title and each of the 3 fields available on each Member;
  • Column and Row sizes;
  • Header & Footer for printing

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (ExOrgChartMaker2.xls).  Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file).  Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. The DEMO version of other products can be also included for evaluation purposes. There is a README.TXT tet file on the ZIP with a full description of its contents.

Based only in EXCEL - No installation or setup required. Just open in Excel and run! 

Try our FREE DEMO

Download and try our FREE DEMO. It works exactly as they Full Version except for these restrictions:

  • None (no restrictions) while using the Original Sample Data as provided by OfficeHelp.Biz:
    • This allows you to freely test the macro functionality, but restricted to our sample data;
    • Original Sample Data can be restored using the "Reset DEMO Data" button on the Input sheet;
        
  • Maximum of 15 nodes if using data different from our own Original Sample Data:
    • Extra nodes on the member list will be ignored;
    • Limit applies to drawing order, not data entry order;

Download your FREE DEMO here! 

Don't wait any more! Create YOUR OWN version of the Organization Chart Maker for Microsoft Excel.

(How to Buy)

Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


Contact Us for Support Help Information FREE DEMO


Get FREE PC TIPS every month:

 

Organization Chart Maker for Microsoft® Excel® - Version 2.10

Tested on Microsoft Excel Versions: 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 2003

(How to Buy)

Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz