To edit an org chart in Excel, click a box and change its text, or select the chart and use SmartArt Design > Add Shape to add a role. Use the SmartArt text pane to adjust reporting levels and order. These steps are for Excel for Microsoft 365 on Windows; first identify whether your chart is SmartArt, separate shapes, or a picture, because each is edited differently.
What You’ll Need
- A copy of the workbook saved before you make substantial changes. SmartArt and shapes can be hard to restore to their original arrangement.
- Accurate employee names, job titles, and reporting relationships, including the intended manager for each person.
- Excel for Microsoft 365 on Windows for the full set of SmartArt and shape-editing controls. On Mac, the corresponding contextual tabs are generally named SmartArt Design and Shape Format. If Excel for the web does not show the controls you need, open the workbook in the desktop app.
Step-by-Step
- Save a working copy and identify the chart type. Use File > Save As to create a copy before editing. Click the chart once. If the ribbon displays SmartArt Design and Shape Format, it is SmartArt. If a single box gets its own handles when clicked, the chart is probably made from individual shapes, possibly grouped together. If the whole graphic selects as one object and no individual boxes can be selected, it may be a picture. Identifying the type first prevents you from looking for SmartArt tools on an image or plain shapes.
- Open the SmartArt text pane, if available. Select the SmartArt chart, then choose SmartArt Design > Text Pane. The pane shows the chart’s labels as an indented outline. A top-level bullet represents a top-level box; an indented bullet represents a person reporting to the item above it. If the pane is already open, click in it. You can also edit a box by clicking it and typing directly, but the pane is usually easier for checking the hierarchy and changing several names.
- Update existing names and titles. In the text pane, click the text you need to change and edit it. Keep a person’s name and title on the same line if that is how the rest of the chart is organized. For example, replace “Jordan Lee – Analyst” with “Jordan Lee – Senior Analyst.” To make a line break inside a box when editing directly, press Alt+Enter on Windows; on Mac, use Option+Return. Check the box afterward to ensure the break did not make it too tall or crowd nearby text. Changing a label does not update an HR system or a separate worksheet automatically.
- Add a new employee or position. In the text pane, select the existing person who will be the new employee’s peer or manager. On SmartArt Design > Add Shape, choose the placement that matches the relationship: Add Shape After or Add Shape Before for a peer, Add Shape Below for a direct report, and Add Shape Above for a manager. The available choices can vary with the selected position and SmartArt layout. Enter the new label in the blank box or text-pane bullet. Confirm that the box appears under the intended manager, not merely in the right visual position.
- Change a reporting relationship or move a person. The text pane is the clearest way to change hierarchy. Select the person’s bullet and press Tab to indent it as a direct report to the item above; press Shift+Tab to outdent it one level. On Mac, use the same keys if they are not intercepted by system or accessibility settings. You can also use SmartArt Design > Promote or Demote when those controls are available. To change the order of peers, move their bullets up or down in the pane. Review the resulting chart carefully: changing indentation changes the reporting line, while changing order alone does not.
- Remove a box or correct an accidental change. Select the correct bullet in the text pane and press Delete or Backspace, depending on your keyboard. You can also select the corresponding SmartArt box and press Delete. Make sure you are removing the intended employee and not a manager whose removal could alter the structure. If you make a mistake, use Ctrl+Z on Windows or Command+Z on Mac immediately. Undo may reverse several edits, so check the chart after each undo.
- Choose a layout that fits the updated hierarchy. Select the SmartArt and open SmartArt Design. In the Layouts group, choose a suitable hierarchy layout, or use More Layouts if shown to browse options. A compact layout may fit a wide team better, while a standard hierarchy can make reporting lines easier to follow. Changing layouts can move boxes and alter spacing, so it may take a moment to compare the result. A layout changes the presentation, not the underlying reporting relationships in the text pane.
- Adjust the appearance and check readability. Use SmartArt Design > Change Colors or a SmartArt Style to change the chart’s overall look. To format an individual box, select it and use Shape Format for options such as fill, outline, and text styling. Avoid shrinking the font until every label fits; try widening the chart, changing the layout, or shortening nonessential title wording first. Zoom out to see whether the full chart fits on the worksheet, then zoom back in to check that names remain legible.
- Review, save, and share the result. Follow each reporting line from the top of the chart down and compare it with your source information. Check spelling, titles, duplicates, missing people, and the level of every new box. If you need a printed copy, use File > Print to inspect the preview and adjust orientation or scaling so the chart is not clipped or made too small to read. Save with Ctrl+S on Windows or Command+S on Mac. If the chart must be updated again later, note that SmartArt text is not automatically synchronized with a separate employee list.
Common Mistakes
- Changing the visual order instead of the reporting level. Moving a bullet above or below another peer only changes its order. Indenting or outdenting changes who reports to whom. Verify the outline as well as the diagram.
- Using Add Shape without selecting the right reference box. Excel places the new box relative to the selected person. Select the intended peer, manager, or report first, then check the resulting connection before adding more people.
- Editing a displayed image as if it were SmartArt. A screenshot or flattened image does not contain editable employee boxes. It needs to be recreated from source data or replaced with the original editable chart.
- Formatting boxes one at a time too early. A later layout or style change can alter spacing and appearance. Finish the hierarchy first, then apply broad formatting and make only necessary individual adjustments.
- Assuming a chart is linked to employee data. In many workbooks, SmartArt labels are independent text. Updating a name in a table does not necessarily update the chart, so verify both locations if the workbook has a separate roster.
Tips
- Use consistent label patterns, such as name on the first line and title on the second, so readers can scan the chart quickly.
- Make a short list of reporting changes before editing. It is easier to check a set of manager-to-report relationships than to judge the chart by appearance alone.
- For a busy organization, edit structure in the text pane and inspect the graphic after each group of changes. That helps catch a wrong indentation before it affects several boxes.
- Leave enough white space between levels and teams. A chart that fits only when viewed at a tiny zoom level may not be useful in a meeting or on a printed page.
- Keep a source roster with columns for employee, title, and manager if the organization changes often. Treat the chart and roster as separate unless you have specifically built a process that synchronizes them.
- When the chart is made from individual shapes, use the worksheet’s alignment and sizing controls consistently rather than dragging boxes by eye. Zoom in while selecting small connectors, then zoom out to check the overall balance.
Troubleshooting
- SmartArt Design does not appear. Click the chart once, rather than a nearby cell or the worksheet background. If only Shape Format appears, you may have selected an individual shape. If no contextual tab appears and the object selects as one image, it may be a picture rather than editable SmartArt.
- The chart or a box will not move or change. The sheet may be protected. Check Review > Unprotect Sheet; a password may be required. Also check whether the workbook is opened read-only or whether the object is locked. If it is a grouped collection of shapes, select the group and use Shape Format > Group > Ungroup only if you need to edit individual items; grouping commands can vary depending on the selected objects.
- A new employee appears at the wrong level. Open the text pane and inspect the bullet indentation. Use Tab or Shift+Tab to correct the level, then verify the connector line in the chart. Do not rely only on where the box happens to sit on the page.
- Text is clipped, boxes overlap, or the chart becomes too wide. Try a different hierarchy layout, shorten long titles without losing essential meaning, or enlarge the chart area. If the graphic uses separate shapes, resize or reposition boxes and connectors carefully. For printing, check the preview and use landscape orientation or a larger page size rather than reducing the content until it is unreadable.
- Changes seem to disappear or affect the wrong object. Check whether you are editing the original workbook or a downloaded copy, and look for a read-only banner. Use Ctrl+Z or Command+Z promptly if an edit went wrong. If the chart is a picture or a linked object that cannot be edited in Excel, return to the source file or recreate it as SmartArt.
Frequently Asked Questions
Can I edit an org chart in Excel without SmartArt?
Yes. If it is made from individual shapes, click a box to edit its text and use the Shape Format tools to resize or format it. Connectors and positions may need manual adjustment. If it is a picture, its labels and boxes are not individually editable.
How do I add a new manager in the middle of an org chart?
Select the person who should report to the new manager and use SmartArt Design > Add Shape > Add Shape Above if that option is available. Then check the text-pane indentation and connectors to confirm that the new manager is placed between the correct levels.
Can I import an employee list to make or update the chart?
Excel’s standard SmartArt org chart is edited through its text pane; it does not automatically sync with a normal employee table. You can use the list as a reference while editing, or use a separate chart-building method if you need a repeatable data-driven workflow.
Why does changing the layout move boxes around?
Layouts arrange the same hierarchy in different ways to fit available space. The positions and spacing may change even though reporting levels remain the same. Check the text-pane outline and connector lines after switching layouts.
Can I edit an org chart in Excel for the web?
Some workbook objects can be selected or have text edited in the browser, but the full SmartArt and shape controls may not be available in every web experience. Open the workbook in desktop Excel for Microsoft 365 if you need to change hierarchy, layout, or detailed formatting.
Related
- How to Delete Duplicate Names in Excel Without Losing Data
- How to Delete Duplicate Data in Excel
- How to Delete Duplicate Entries in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Line Chart With Data Labels: Add and Format ThemTo add data labels to an Excel line chart, select the chart and choose Chart Design > Add…
- Excel Bar and Whisker Chart: How to Create and Read OneAn Excel bar and whisker chart, more commonly called a box-and-whisker chart or box plot, summarizes the distribution…
- Excel Chart Gridline Interval: How to Set ItIn Excel for Microsoft 365 on Windows, set a chart’s gridline interval by formatting the axis that the…
- Excel Chart Reverse Order: Flip Categories or ValuesTo reverse an Excel chart’s category order, right-click the category axis, choose Format Axis, then under Axis Options…
- Excel Pivot Table Filter Multiple Values: Quick GuideTo filter a PivotTable to several values in Excel for Microsoft 365 on Windows, open the drop-down for…
- Excel Radar Chart Scale: Set the Minimum and MaximumIn Excel for Microsoft 365 on Windows, select the radar chart’s numeric value axis, right-click it, and choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.