SOLVED

Missing Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-1061026%22%20slang%3D%22en-US%22%3EMissing%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1061026%22%20slang%3D%22en-US%22%3E%3CP%3ESuddenly%20all%20charts%20in%20the%20workbook%20disappeared%2C%20on%20all%20sheets.%26nbsp%3B%20There%20were%20approximately%2050%20charts.%20Why%3F%26nbsp%3B%20How%20to%20recover%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1061026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1061590%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1061590%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20your%20File%26gt%3B%20Options%20setting%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161281i4E31EE3D9A814185%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1062997%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1062997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3Bthank%20you.%20You're%20beautiful.%20I%20have%20no%20idea%20how%20that%20item%20got%20unchecked.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1063819%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063819%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1325006%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1325006%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3BSo%20I%20had%20the%20exact%20same%20issue%2C%20but%20this%20did%20not%20solve%20it.%26nbsp%3B%20Any%20other%20thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1334627%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334627%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F630961%22%20target%3D%22_blank%22%3E%40Penguinmike66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20try%20the%20Selection%20Pane%20to%20see%20what's%20there%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorWyn%20Hopkins_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186405i77A7A04BCB863200%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Suddenly all charts in the workbook disappeared, on all sheets.  There were approximately 50 charts. Why?  How to recover?

5 Replies
Highlighted
Best Response confirmed by Broker3000 (New Contributor)
Solution

Check your File> Options setting

 

clipboard_image_1.png

Highlighted

@Wyn Hopkins thank you. You're beautiful. I have no idea how that item got unchecked.

Highlighted
You’re welcome
Highlighted

@Wyn Hopkins So I had the exact same issue, but this did not solve it.  Any other thoughts?

Highlighted

@Penguinmike66 

 

You could try the Selection Pane to see what's there

 

 

image.png