Microsoft Office Tutorials and References
In Depth Information
The other two horizontal maroon lines were created using cell
The light gray background is a custom shade of gray. To assign it,
you first need to set up the color. To do so, choose Tools, Options,
and then select the Color tab. Select a color you won’t need in your
current workbook. Choose Modify. In the Standard tab of the Colors
dialog, choose a color that you want to use. Or, in the Custom tab,
you can specify any color you want.
After you set up the new color, you can assign it as you would any
other color. Select the range you want, choose Format, Cells. Then
in the Patterns tab assign the new color to the selected range.
The previous figure uses the most-common but least-flexible
method to display tables in dashboard reports. The two tables in
columns C through G consist of actual spreadsheet cells. Chapter 5
explains how to create the table in another worksheet and display a
live image of it in your report.
The charts’ SERIES functions and the formulas in columns E, F,
and G, all get their data from other pages in the report workbook.
Chapter 8 discusses the structure of the full workbook.
Each column of charts in the report uses the same values for their
Y axes. Such uniformity is necessary in this report, because the
companies’ measures are much easier to compare when the charts
use identical scaling within each column.
This section explains how to set up several charts to have identical
values for the Y axis. It also explains how to do this for the X axis,
which is easier to do. I call this process common scaling .