format legend name

Occasional Visitor

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.

1 Reply


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.


Detailed information in the inserted link

Modify chart legend entries


I would be happy to know if I could help.



I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.