 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
As Leo mentioned on the show, you can get a free copy of this other book - Learn Excel 97-2007 from MrExcel at leobook.html.
There is also an e-book that I wrote with everything you would ever need to know about SmartArt. Check out Leveraging SmartArt.
Office 2007 offers 84 new types of business diagrams. It is easy to build and customize the diagram with the SmartArt feature.
- From Word, PowerPoint or Excel 2007, Choose Insert – SmartArt
- Choose one of the layouts (this can be changed later)
- Build your message in the text pane. Excel automatically resizes the text in the graphic to fit and keep all shapes balanced.
- Choose a color scheme.
- Choose an effect from the five 2-D styles or 7 3-D styles.
- Note the last style is great for sharing bad news (no one can read anything)
- Show how easy to present the same message in new shapes by changing to a new layout.
- Create the SmartArt with dummy text.
- Select one shape in the diagram.
- Press Ctrl+A to select all shapes.
- In a blank section of the worksheet, paste a copy of the SmartArt. But – it is no longer SmartArt – it is now a collection of Excel shapes!
- Select a shape. Click in the Formula bar. Type =A1 and press Enter. The value in the shape now comes from cell A1.
- Repeat for each shape.
I really hope to give away 5 million copies of the book, so please send your co-workers and friends to
leobook.html.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.