Forum Discussion
Chart disappearing when copy tab to new file
For some reason charts disappear when I "move or copy" a tab from one xl file to another one. Do you know how to fix this? Thanks!
Hi, this issue can happen because when you copy a worksheet that contains charts, Excel may not update the data or formula references correctly in the new file. Here are a few things you can try:
-Ensure Compatible File Formats - Both workbooks should be saved in a modern format like .xlsx.
-Check Data References - Make sure the charts aren’t linked to external ranges or named ranges that haven’t been copied over correctly.
-Manually Copy the Charts - Instead of moving or copying the entire tab, try copying the charts individually and then pasting them into the new file.