Microsoft Office Tutorials and References
In Depth Information
ADD FORMULAS TO SMARTART
Repeat step 6 to assign =H9 to the second shape and =H10 to the third
You now have something that looks like a SmartArt diagram, but the text for the
shapes comes dynamically from the worksheet (Figure 81).
Figure 81. Now the text in the diagram is a live result from the data.
As the query in A:C updates with new sales, the formulas in E:H and thus the
text in the diagram automatically update. While Mary was on a break, Ted
made a $395 sale. The worksheet updates as shown in Figure 82.
Figure 82. Excel dynamically calculates the text in this SmartArt.
Summary: Although SmartArt in Excel 2007 cannot dynamically update,
you can use SmartArt to create a diagram and then convert it to shapes and