Create Diagrams

Excel provides a separate set of tools for creating organization charts and diagrams. To draw an org chart of a diagram in Excel:

  1. On the Drawing toolbar, click Insert Diagram or Organizational Chart. Excel displays the Diagram Gallery as shown in Figure 18-3.

    Adding a diagram to a worksheet

    Figure 18-3. Adding a diagram to a worksheet

  2. Choose a diagram type and click OK. Excel creates a default diagram on the active worksheet and displays the Diagram toolbar (Figure 18-4).

    Use the Diagram toolbar to add items and control formatting

    Figure 18-4. Use the Diagram toolbar to add items and control formatting

  3. Use the Diagram toolbar to add items to and control the appearance of the diagram.

  4. Click on labels in the diagram to add text as shown in Figure 18-5.

    Editing text in a diagram

    Figure 18-5. Editing text in a diagram

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.