Forum Discussion

chas707's avatar
chas707
Copper Contributor
May 01, 2024

OPENED FILE AND ALL CHARTS WERE MISSING

So, I have been using this spreadsheet since 2014 and have always upgraded it to stay current. I had a file in Jan 2024 that I added data to and saved. Last month (Apr), I opened the file to add new data as I always have, and all my charts were gone. I've searched and cannot fight how these charts were deleted. It was not me. I've looked for fixes and there is little to no similar issue to mine unless my search was weak.

 

I'm looking for ideas, and while I am not a computer engineer, I know Excel and lots more. I already tried the options, checkmark solution.

 

Thanks in advance

charley

Charting
excel
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    Check for Hidden Objects or Sheets
    Sometimes charts might be hidden rather than deleted.

    Unhide Sheets: Go to the Sheet tab at the bottom of Excel, right-click, and select Unhide to ensure no sheets were hidden.
    Check for Hidden Objects: Charts might be moved or hidden behind other objects. Use Find & Select to locate hidden objects:
    Go to Home > Find & Select > Selection Pane. This pane allows you to see all objects on the sheet and unhide them.

Resources