SmartArt in Office 2007
August 23, 2006
One of the cool new features in Office 2007 are the business diagramming tools. Microsoft calls these SmartArt.
SmartArt is available in Excel 2007, Word 2007, and PowerPoint 2007. It actually works a little bit better in PowerPoint 2007.
In PowerPoint, you can highlight any existing text, right click, and choose Convert to SmartArt.
Office will convert the text to a SmartArt graphic.
SmartArt is available in 84 built-in layouts. There are layouts for cycle charts:
Layouts for picture lists:
The big letdown is that Microsoft did not have time to finish one important feature. In the old AutoShapes, there is a trick to have the text in the AutoShape come from a value in a cell. SmartArt does not allow this.
On the show, I mentioned that I figured out a workaround.
- Create the static SmartArt.
- Use the Design and Format ribbons to get the graphic as close to finished as possible.
- Click inside the SmartArt border, but not on any shape in the SmartArt.
- Type Ctrl + a to select all of the shapes.
- Ctrl + c to Copy
- Select a new cell outside of the SmartArt
- Ctrl + v to paste. You now have an identical copy of the SmartArt, but this version is actually made up of AutoShapes.
Once you have a diagram comprised of old fashioned shapes, you can use the familiar trick to make the text come from another cell.
- Select the text in the Shape
- Click in the Formula Bar
=G45and press enter. This formula will put the results of the formula in G45 as the text in the shape.
- Repeat steps 1 - 3 for each additional shape
The diagram below was created with these steps. Every time that a new value is calculated in G45:G48, the text in the shape is updated.
SmartArt is a cool new feature in Office 2007.