Skip to main content

Advance Organization Chart

Garden City Consultants

An enhanced version of Organization Chart requested by user to add more customizable features

Description:

Advance Organization Chart Add-In is a tool for creating organization chart in Excel. This version is requested by the user to add the features of customizing the font name, size, color in the name, title fields and the node.

Features:

  • Customizable font name, color, size, style in the name and title field.

.

  • A check box for enabling/disabling the Collapse of the nodes when double clicking the node.

.

  • Customizable color and size for the nodes.

.

  • Interactive chart allows the user see the chart update while entering the data.

.

  • 36 preset colors can be used to set the foreground and background colors for the name, title and the node.

.

  • 8 font families can be selected for the name the and title.

.

Instruction:

  • Download this add-in and start Excel 2013 SP1 or later.

  • Click Insert sample data button to insert sample data.

  • In the setting window, select font color, name, size, style for the name and title fields.

  • In the setting window, select the node color and size.

  • The user can paste own data in the same format into the sheet to replace the existing sample data or create own table in the same sheet. The first column is name, the second column is manger, the third column is the title or department name.

  • The chart is binding to the table. You can see the chart update along with the data entered.

  • If the user have multiple tables in the sheet, you can click the tool icon to go to the setting screen and click Bind to existing data button and select the table.

  • The user can give a title to the chart by clicking in the title area and enter the name as preferred.
Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949682288/Asset_c84e3b3d-6260-4462-9294-5d2cb26659a3/AdvOrgChart3.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949682288/Asset_c84e3b3d-6260-4462-9294-5d2cb26659a3/AdvOrgChart3.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949682288/Asset_a14dc3b7-9421-41fe-b98f-1a3a23bd82d8/AdvOrgChart1.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949682288/Asset_26a25be2-e6e3-411c-aaf9-9c2530de2f42/AdvOrgChart2.jpg