Microsoft Office Tutorials and References
In Depth Information
FIGURE 7.15 Fixing the Range of Values of the Axis
FIGURE 7.16 The Two Scroll Bars on the Chart
value is $12 for the Unit Price.Wewould like it to vary from$10 to $20. The incremental
change will be $1. Page Change is irrelevant for this example. We are controlling the
price as you see on the Cell Link (the cell C2 on the Animate a Chart sheet.)
To configure the second scroll bar for the Unit Cost follow a similar process:
Right-click on the bar and choose Format Control. On the Format Control you can
enter the information as you see in Figure 7.18. The Current value is $8 for the Unit
Cost. We would like it to vary from $5 to $15. The incremental change will be $1.
Again, Page Change is irrelevant for this example. We are controlling the price as you
see on the Cell Link (the cell C3 on the Animate a Chart sheet).
Now when you make a presentation you will see the lines moving as you click on
the arrows of the scroll bars. The first scroll bar will move the Revenue line up and
down. The second scroll bar will move the Expenses line up and down. The Break-
Even Point will be changing as the lines are moving.