Microsoft Office Tutorials and References
In Depth Information
Creating the chart
Figure 7-13: Pressing F9 displays the data in the row that contains the
cell pointer.
Creating the chart
The chart is a standard column chart, created using the data in rows 2 and 3. Notice
that the height of row 1 has been increased to accommodate the chart. The
workbook uses “frozen panes” to keep row 1 in view at all times. To freeze the panes,
select cell A2 and choose Window
Freeze Panes.
Defining the names
The chart uses two named formulas. Unlike the other named formulas in this
chapter, these formulas are defined using “mixed” cell references (the column part
of the reference is absolute, but the row part is relative). Using non-absolute cell
references adds a new twist to named formulas, because the formula evaluates
differently, depending on the active cell at the time the sheet is calculated.
In fact, the location of the active cell is critical when you create the named
formulas. The following names assume that cell A3 (in the first data row) was active
when the names were created.
ChartTitle is defined as
=OFFSET($A3,0,0)
ChartData is defined as
=OFFSET($A3,0,1,1,5)
Search JabSto ::




Custom Search