You need to visualize a company structure or a process flow directly in your Excel workbook. Excel’s SmartArt graphics provide a built-in tool for creating professional diagrams. This article explains how to insert and customize SmartArt to build clear org charts and flowcharts without leaving Excel.
Key Takeaways: Building Diagrams with SmartArt
- Insert > Illustrations > SmartArt: Opens the SmartArt gallery where you select the diagram layout for your org chart or flowchart.
- SmartArt Design and Format contextual tabs: Change colors, styles, and shapes after you add the graphic to your sheet.
- Text Pane: A side panel that lets you quickly type and organize the text for each shape in your diagram.
Understanding SmartArt Graphics for Diagrams
SmartArt is a collection of pre-designed graphic layouts built into Excel. It transforms bulleted lists into visual diagrams. For organization charts, it automatically arranges shapes in a hierarchy. For process flows, it connects shapes in a sequence. You only need to add your text. The tool handles alignment, spacing, and connector lines. This saves significant time compared to drawing shapes manually.
Before you start, have your data ready. For an org chart, know the reporting structure and employee names. For a flowchart, list each process step in order. SmartArt works best with a clear plan. You can choose from several dedicated layouts. The Hierarchy category contains multiple org chart styles. The Process category offers various flowchart templates. You select the one that matches your visual goal.
Steps to Insert and Build Your Diagram
Follow these steps to create a diagram from scratch.
- Go to the Insert tab
Click on the Insert tab in the Excel ribbon. Locate the Illustrations group. - Click the SmartArt button
In the Illustrations group, click the SmartArt icon. This opens the Choose a SmartArt Graphic dialog box. - Select your diagram category and layout
In the left pane, click a category. For an org chart, select Hierarchy. For a flowchart, select Process. Click a layout thumbnail in the center pane to see its description on the right. Select one and click OK. - Add text using the Text Pane
The SmartArt graphic appears on your worksheet. A Text Pane opens to its left. If it does not open, click the small arrow on the left border of the graphic frame. Click each bullet point in the Text Pane and type your text. Press Enter to add a new shape at the same level. Press Tab to indent and create a subordinate shape in an org chart. - Add or remove shapes as needed
Click on a shape in your diagram. The SmartArt Design tab appears on the ribbon. In the Create Graphic group, use Add Shape to insert a new shape after, before, above, or below the selected one. To remove a shape, click its border and press the Delete key.
Customizing the Design and Format
- Change the color scheme
With the SmartArt graphic selected, go to the SmartArt Design tab. Click Change Colors in the SmartArt Styles group. Choose a color variant from the gallery. - Apply a SmartArt Style
In the same tab, browse the SmartArt Styles gallery. Hover over options to see a live preview. Click a style to apply effects like shadows or 3D formatting. - Format individual shapes
Click on a specific shape within the graphic. The Format tab appears. Use the Shape Styles options to change its fill, outline, and effects. You can also change the shape itself with Change Shape in the Insert Shapes group. - Adjust size and position
Click the border of the entire SmartArt graphic to select it. Drag the corner handles to resize it proportionally. Click and drag the center of the graphic to move it on the worksheet.
Common Mistakes and Limitations to Avoid
Text Does Not Fit in the Shape
If your text is too long, it may shrink or be cut off. Do not use long sentences. Use short titles or names. You can also make the shape larger. Select the specific shape and drag its sizing handles. Alternatively, reduce the font size. Select the text, then use the font size control on the Home tab.
Need to Show a Complex Reporting Structure
Standard Hierarchy layouts show one manager above direct reports. For an assistant or a position that reports to two managers, the basic layouts may not work. Use the SmartArt Design tab. Select the shape for the assistant. Click the Add Shape dropdown and choose Add Assistant. This inserts a special connector shape.
SmartArt Graphic Looks Blurry or Pixelated
This happens if you copy the graphic as an image or if your system display scaling is high. For the best quality, always keep the graphic in its native SmartArt form within Excel. When copying, use the Copy command on the graphic itself. Paste it into another Office app like Word or PowerPoint to retain its vector quality.
SmartArt vs Manual Shapes: Key Differences
| Item | SmartArt Graphics | Manually Drawn Shapes |
|---|---|---|
| Creation Speed | Fast, with automatic layout and alignment | Slow, requires manual placement and connecting |
| Layout Consistency | Uniform shapes and spacing applied automatically | Inconsistent without careful manual adjustment |
| Text Management | Centralized editing via the Text Pane | Text must be edited inside each shape individually |
| Design Changes | Apply global style and color changes instantly | Each shape must be formatted separately |
| Best For | Standard hierarchies and process flows | Highly custom or non-standard diagram designs |
You can now build professional org charts and flowcharts directly in your Excel sheets. Use the Hierarchy and Process categories in the SmartArt gallery to start. Try applying a different SmartArt Style to instantly change the look of your entire diagram. For more control, remember you can right-click any shape and select Format Shape for advanced options like gradient fills.