Next, lets create two named ranges—one for the Xs and one for the Ys—that will be used as data ranges for the chart.
7. On the Formulas tab, in the Defined Names group, click Define Name.
8. In the New Name dialog box, in the Name box, type lstX.
9. In the Refers to box, click the Collapse Dialog button (which temporarily shrinks the dialog box), select cell B8 on the worksheet, type # at the end of the reference and then click the Expand Dialog as follows: