A legend box in an Excel chart lists the chart's data series. It specifies each series' name and the color of its marker on the chart. When you try to edit a legend using the Format Legend dialog ...

Select the "Data" tab from the Excel Ribbon. In the Get External Data section, click on the "From Text" button. Locate your file in the Import Text File dialog box.

Click Macros in the Code group. In the resulting dialog, choose SelRange () as shown in Figure A and click Run. When prompted, select any range (see Figure B), and then click OK. Figure A Figure B ...