Site icon Professor Excel

Images, Charts, Objects Missing in Excel? How to Get Them Back!

This is a problem that occurs once a while in Excel: Some objects are not showing. Most often, images or charts are not showing. Here are the possible reasons if charts, objects or images are missing and how to get them back!

Possible reasons for missing images and charts in Excel

You had images, charts or other objects (e.g. drawing) in your Excel workbook, but now they are gone? There are basically two possibilities:

  1. You’ve (accidentally) deleted them?
  2. They are just not being displayed.

So, let’s see now how to get them back.

Reason 1: How to get images and charts back if you have deleted them

If you are sure that you have not accidentally deleted charts or images, just scroll down to reason number 2.

If you have deleted pictures, charts or objects, try these things:

Reason 2: Simply display images within the Excel options

There is a hidden setting in Excel with says “For objects, show:”. Here you can select if you want to show all such objects. Objects are in general everything which is not inside cells. So everything from images, drawings, charts, drop-down lists, etc.

Images, charts, drawings etc. missing? Click “For objects, show all” within the Excel options.

You can easily reactivate them. But it’s a little bit hidden:

  1. Go to File and click on Options.
  2. On the left side click on “Advanced”.
  3. Scroll down to the “Display options for this workbook:”. The last bullet point says “For objects, show:”. Set the tick at “All”.

That’s it

Image by Amanda Elizabeth from Pixabay

Exit mobile version