Microsoft Office Tutorials and References
In Depth Information
and columns in the ranges that the Camera objects reference. As
you adjust those rows and columns, the Camera object will expand
or contract as appropriate.
Set Up Alternate Figures
One of the benefits of using Excel for dashboard reporting is that
you can quickly change the report. However it’s not unusual to try
certain changes and then decide that the original version was the
best version after all.
Therefore, when you make changes to a dashboard report, it’s a
good idea to plan for those changes to be reversed.
Most Excel users protect themselves in this regard by saving
multiple generations of their reports. Then, if changes need to be
reversed, they can revert to an earlier generation. But this
technique often won’t work with dashboards, because many
different figures can be changed or restored. Therefore, no earlier
generation has just the combination of figures you really need.
A More Flexible Way to Plan for Undoing Changes
The most frequent type of change is to replace a particular chart or
table with a different figure. What takes the time is to create the
data sheet to support that new figure. It takes just a few seconds to
point a figure to that new data.
Therefore, it’s often a good idea to leave recently removed data
sheets in your report workbook for a short time, just in case your
boss wants to undo some of the changes she’s requested for her
However, it’s also a good idea to remove data sheets that probably
won’t be used any time soon. Otherwise, your workbook grows
bigger and slower with each new change.