Microsoft Office Tutorials and References
In Depth Information
Modifying the series
After you perform these steps, the workbook contains two new names, Date
and Sales .
Modifying the series
The final step is to modify the chart so that it makes use of the two new names
rather than the “hard-coded” range references.
1. Activate the chart and select Chart
Source Data to bring up the Source
Data dialog box.
2. In the Values field, enter Sheet1!Sales .
3. In the Category (x) axis labels field, enter Sheet1!Dates .
4. Verify that the dialog box looks like Figure 7-3 and then click OK.
Figure 7-3: Specifying the named formulas
in the Source Data dialog box
In Steps 2 and 3, note that the name was preceded by the worksheet name and
an exclamation point. Because named formulas are workbook-level names (as
opposed to sheet-level names), you should (technically) enter the workbook name,
an exclamation point, and the name. However, Excel is very accommodating in this
regard, and changes it for you. If you access the Source Data dialog box again,
you’ll discover that Excel substituted the workbook’s name for the sheet reference
you entered:
=daily.xls!Sales
Search JabSto ::




Custom Search