Microsoft Office Tutorials and References
In Depth Information
19. Click the filter arrow that appears and then, in the filter menu, clear the Select All
Excel removes the check boxes from the filter list items.
20. Select the Northeast check box, and then click OK .
Excel filters the PivotChart.
CLEAN UP Save the RevenueAnalysis workbook, and then close it.
Creating Diagrams by Using SmartArt
As an international delivery company, Consolidated Messenger’s business processes are
quite complex. Many times, chief operating officer Lori Penor summarizes the company’s
processes for the board of directors by creating diagrams. Excel has just the tool she needs
to create those diagrams: SmartArt. To create a SmartArt graphic, on the Insert tab, in the
Illustrations group, click SmartArt to display the Choose A SmartArt Graphic dialog box.