Microsoft Office Tutorials and References
In Depth Information
D23: =MONTH(D$7)&CHAR(13)&RIGHT(YEAR(D$7),2)
Displays the month number, a carriage return, and then the year
number as two characters. Copy this formula to cell P23.
O23: =MONTH(O$7)
Displays only the month number. Copy this formula to the range
E23:N23.
Rows 24 and 25 contain formulas that return raw data, scaled as
specified by the scale type.
D24: =D$12*Scale
Copy this formula to the range D24:P25.
Assign the labels in column C of the Chart Data area as names for
the data to be charted. (Be sure that you’ve already entered these
labels in the Reserved Names section of the Control sheet, and
created those global names.) To assign the names in this
worksheet, select the range C23:P25. Choose Insert, Name,
Create. In the Create Names dialog, ensure that only the Left
Column is checked. Then choose OK.
To complete this step, name the data sheet “A”, without the quotes.
You’ll name the next data sheet B, and then C, and so on. Using
short worksheet names like this brings two benefits. First, you’ll be
able to see as many tabs as possible in your workbook, which
makes them easier to find. Second, you’ll find it easier to set up the
dashboard in the first place.
Search JabSto ::




Custom Search