Using table name in a chart

[franklinsam]

I am copying a chart from tab 2023 to tab 2024 in my workbook. When I do this the table in tab 2024 references the data in tab 2023. Is there a way to get the location of the data to change with the tab name.

 

[Greenbehindthecells]

Good afternoon,

I would suggest to select the chart (new chart you copied from old 2023 chart), go to the Design tab in the toolbar, select "Select Data" to change the data in your new chart to the 2024 data- unless its a pivot chart, where I do not know of a way to do this.