On the Chart Design tab, in the Data group, click the Select Data

button. The Select Data Source dialog box opens.

In the Legend Entries $($Series$)$ box, click Series$1,$ and then click

Edit. The Edit Series dialog box opens.

With the insertion point in the Series name box, click cell $J5$ to

insert the reference $=$ Income!$J$$5,$ and then click $OK.$ The Select

Data Source dialog box reappears with the Series$1$ name changed

to $$1,000.$ See Figure $8-18.$

Figure $8-18$ Select Data Source dialog

box