Microsoft Office Tutorials and References
In Depth Information
Animating Charts
FIGURE 7.17 The Scroll Bar Menu
FIGURE 7.18 The Scroll Bar Controlling Cost
We can add a Text Box on the chart to show the BEP changing on the chart itself
(a dynamic Text Box). To add a Text Box we go to the Insert Ribbon and insert one
on the chart. To link the Break-Even Point value to Text Box, making it dynamic,
follow these steps:
Select the Text Box.
n
Click in the Formula Bar.
n
Type
in the formula bar and click on the Break-Even Point Cell on the Ani-
mate a Chart Sheet (it will read:
¼
n
¼‘
Animate a Chart
!$C$9).
Search JabSto ::




Custom Search