Microsoft Office Tutorials and References
In Depth Information
Modifying the series
Bottom line? When using these named formulas, you can precede the name with
either the worksheet name or the workbook name (I find it easier to use the
worksheet name). But keep in mind that if the sheet name or workbook name includes a
space character, you must enclose it in single quotation marks, like this:
=’daily sales.xls’!Sales
or
=’sales data’!sales
For more information about names, refer to the sidebar “How Excel Handles
Names.”
An alternative to using the Source Data dialog box is to edit the chart’s SERIES
formula directly.
How Excel Handles Names
Excel supports two types of names: workbook-level names and worksheet-level
names. The scope of a workbook-level name is the entire workbook. Normally, when
you create a name for a cell or range, that name can be used in any worksheet.
You can also create sheet-level names. A sheet-level name incorporates the sheet name
as part of its name. For example, Sheet1!Data is a sheet-level name. When you create
this name, you can use it in formulas in Sheet1 without the sheet qualifier. For example:
=Data*4
But if you enter this formula in a different worksheet, Excel will not recognize the
name unless you fully qualify it:
=Sheet1!Data*4
Sheet-level names are useful because they enable you to use the same name on
different worksheets. For example, you might create sheet-level names such as
Sheet1!Interest, Sheet2!Interest, and Sheet3!Interest . Each name refers to a cell on its
own sheet. A formula that uses the name Interest uses the definition for its own sheet.
The named formulas used in this chapter are workbook-level names because they are
not preceded by a sheet name. But when you enter a name in a field in the Source
Data dialog box, Excel (for some reason) requires that you qualify the name with
either the sheet name or the workbook name.
Search JabSto ::




Custom Search