Feb 10 2021 11:05 AM
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.
Feb 11 2021 01:44 AM
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.
Nikolino
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.