When creating a graph chart, the legend should be 2021, 2020, 2019, 2018, etc. When I copy the data for the chart, the legend comes up with Series 1, Series 2, Series 3, etc. How do I edit the legend so that it correlates to 2021, 2020, 2019, etc.
When a chart has a legend displayed, you can modify the individual legend entries by editing the corresponding data on the worksheet. For additional editing options, or to modify legend entries without affecting the worksheet data, you can make changes to the legend entries in the Select Data Source dialog box.