A number of diagram types will probably be familiar to most business people: the pyramid, which shows a hierarchical relationship; the target, which uses a ring of concentric circles to display the approach to a target; the Venn diagram, which shows the intersection of items in various sets; and the cycle, which displays the steps in a repeating process. Rather than make you create these diagrams on your own, you can have Excel create the basic diagram and let you fill in the details. After you’ve created the diagram, you can apply an AutoFormat to alter its appearance.
Insert a Diagram
Click the Insert tab.
Click SmartArt.
Click the category of SmartArt you want to create.
Click the specific diagram you want to add to your worksheet.
Click OK.
Click a text box to add text to your diagram.
Change the Style of a Diagram
Click the diagram you want to change.
Click the Design tab.
In the Layouts group on the ribbon, click the layout you want to apply to the diagram.
Tip
A preview of the new format appears when you hover the mouse pointer over a layout in the Layouts gallery. . . feel free to experiment!