Excel Charts Are Not Showing! URGENT!

Hello,

I am so frustrated right now because some of my charts in Excel are not showing, they are blank. When I right click on the blank ones and select 'Select Data', they show but then when I click 'OK' and leave that tab, they go back to blank. I am using the latest version of Excel. Please help! I have included a print screen so you can get a better idea. Any help would be greatly appreciated! Thanks in advance.

Image

Answer
Answer
Reply In reply to deleted message

Hello,

Luckily, I randomly figured out the solution myself :)

The issue was that I hid the data that I used to create those graphs. So what I did was:

I right-clicked the blank chart and selected 'Select Data', then at the bottom of the tab where it says 'Hidden and Empty Cells', I selected "Show empty cells as Gap" and I ticked the box saying "Show data in hidden rows and columns". This made all the graphs appear again.

Thank you guys for your help!

Have a good day.

29 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 20,102 Applies to: