sponsored ads

How to Make an Organization Chart in Excel 2010

Topic:  Excel, Microsoft Office, Office  Product:  Microsoft Excel , Microsoft Office  Related Articles:  organization chart template reverse hierarchy   vba 2010 smartart   excel dashboard smartart  

An organization chart shows the hierarchy of a company or a project. Each level in the hierarchy is represented by a row of boxes. We need to use this type of chart frequently. Microsoft Excel can create organizational charts through the use of SmartArt hierarchy diagrams in versions of Excel 2010 and earlier versions. Here I will take Microsoft Excel 2010 for example to introduce about how to make an organization chart .

sponsored ads

Solution

  1. In Microsoft Excel 2010, choose "Insert" > "Illustrations" > "SmartArt" tab.
    Make an Organization Chart in Excel 2010
  2. The SmartArt Graphic dialog box pops up. And click "Hierarchy" in the left pane. Select one style and click "OK" to insert.
    Make an Organization Chart in Excel 2010
  3. The organization chart has appeared in the sheet. And the text pane pops up automatically like this. Type your text there.
    Make an Organization Chart in Excel 2010
  4. "SmartArt Tools" tab will appear in the ribbon, including "Design", "Format" command. Click "Design" and you can do many settings.
    Make an Organization Chart in Excel 2010
  5. Under "Design" tab, click "Add Shape" and you can add shapes in the right place, after or before like this.
    Make an Organization Chart in Excel 2010
  6. Click "Change Layout" and choose one type. The chart will become to the selected style at once as follows.
    Make an Organization Chart in Excel 2010
  7. "Change Colors" will help you change the whole color of the chart.
    Make an Organization Chart in Excel 2010
    Make an Organization Chart in Excel 2010
  8. There are other features under "Design", such as "Quick Styles", "Reset Graphic", "Convert to Shapes" and so on.
  9. Click "Format" under "SmartArt Tools" tab.
    Make an Organization Chart in Excel 2010
  10. In "Shape Styles" group, you can select one shape and then choose one style. Like the following, the style will be changed.
    Make an Organization Chart in Excel 2010
  11. "Quick Styles" can help you to make many kinds of the text. As follows you can see.
    Make an Organization Chart in Excel 2010
    Make an Organization Chart in Excel 2010
  12. Under "Format" tab, there are "Arrange", "Size" commands that you can use to make the chart neater and cleaner.
    Make an Organization Chart in Excel 2010
  13. Well done.

Tips

See also

How to Create an Organization Chart with Pictures in Word

How to Make a Combination Chart in Microsoft Excel
Combination charts can let you compare two sets of data with different scales and jazz up an otherwise dull chart. Here I will show you how to make a combination chart in Excel.
How to Make a Pareto Chart in Microsoft Excel
My teacher gave me plenty of statistics and asked me to do with them for him. I'd better use the statistics to make a pareto chart, because this could explain a lot directly. But I am poor about software use. I am only able to use Microsoft Excel a little. I can deal with some data in Excel, but not create charts with data. Next week, my teacher will ask me for it, but I have not begun to do this job. Would someone like helping me?
How to Make Area Chart in Microsoft Excel
I work for my analysis report, and there are a lot of datum, so I find in order to display these datum I should make an area chart, but the problem is how to do that. I hope someone can help me.

Search for Related Topics

dynamic organization chart excel smart charts   flowchart smartart excel 2010   excel 2010 smartart hierarchy   excel 2010 smartart swimlane   inverted hierarchy excel 2010   excel 2010 tick smartart   hyperlink excel 2010 smartart  

Related Unresolved Questions

more »
Options

Authors

Tagged Add my tag

chart , excel 2010 , office 2010 , organization chart , microsoft organization chart arabic , organization chart excel sample , project organization chart excel , generate organization chart excel , design marksheet format ireport

sponsored ads

Recent Searches

create cs5 dreamweaver timeline   acronis convert image vbox   ajax offline save website   3.38 autodata swedish   animation boot change resource windows xp   mse removal tool   audio effects noise reduction  

Download this software from AFC

Microsoft Excel Viewer 2003 1.0

Last Updated: Sep 10, 2008
License: Freeware
Filesize: 9.93MB

Continue to downloadPower by Afreecodec.com