Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Avoid the Unnecessary Use of Menus in Excel and Word 1. In your Microsoft Office Excel and Microsoft Office Word programs, place the mouse over the status bar at the foot of the program window. 2. Right-click to reveal the Customize Status Bar menu, and then select which options you want to appear on the bar. Let Your Audience Drill Down to Excel Data 1. Select the Microsoft Office Excel table that you want to import to your Microsoft Office Visio diagram. On the Ribbon, under Export, click Create Diagram. 2. In the Add Total area of the PivotDiagram panel, select the number of columns that you want to include in your Visio diagram. 3. Select the diagram in your Visio presentation for which you want to create a drill-down facility, and then select the category for your drill-down levels. 4. Add shapes to the categories. a. Select your diagram, and then click the Apply Shape button in the PivotDiagram panel. b. Select the shape you require, and then click OK. 5. Filter the data by clicking Configure Column on the Category menu, and then clicking the arrow next to the category name. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement