How to Stop Your Excel Charts From Disappearing When you Hide Data #shorts

Did you ever have the problem that your chart disappears in Microsoft Excel once you hide the source data? I'll show you how you can fix that with 1 click!

Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

[Otase]

The default option should be quoted! It's like they did it on purpose so you could do this useful video 😄
Sometimes I don't understand the logic behind some Excel's developers choices

[yogibearstie]

Thanks I used it today after seeing your video

[chrism]

I never knew this little trick, thanks Leila!

[smalldjo]

i dont knw why i missed this setting, i always just take the data to another sheet and hide that one

[raccoon]

*HOW DO YOU FIGURE OUT THERE ARE HIDDEN CELLS when the headings/gridlines are checked off?*

[krishnakishorepeddisetti]

I have been working on excel sheets for 10 years... With some really good knowledge on excel... But...i was not aware of this trick... Thank you much leila

[Gseyjcjdsthbcsdujcc]

NEVER hide columns or rows. Why would you suggest this horrible practice? Instead, group columns or rows so that it appears hidden but it’s clear that there’s data there.

For the purpose of charts, if you don’t want the raw data visible, why not just have the data on a separate tab?

[benniepieters]

Why can't that just be turned on by default?!

[ruudb]

Wow! I needed this one since long time already. Thanks!!

[NicBob]

Oh wow! So much better than setting the text font to white like I did 😂😂😂

[SteveS]

Thanks for the helpful video. Unfortunately I do not see this option in Google Sheets. Just a heads up to other users.

[arniecalang]

WHAT??!! I’ve been doing this wrong for the past 15 years

[samuraiswift]

Thank you! Can't believe I didn't notice this before!

[NavaneethaKrishnanK]

Hi. The option for hidden and empty cells is greyed out. How do i enable it

[yavuzatak]

Is there a way to stop disappearing linked pictures at the same time when i hide data

[AlvinRyellPrada]

Omg i was not aware on this approach... What i normally do is to put my reference table on the very right end of my spreadsheet.
Thanks for this straightforward approach 😎🎉

[spilledgraphics]

Always, Group Columns or Rows over Hiding Columns or Row. Group > Hide.

[ΣυμεώνΒογιατζόγλου-ρι]

Hello and thanks for your help. My question that I can not find answer: How do I link ONLY VALUES between spreadsheets NOT CELLS WITH VALUES (google sheet). I want the values to keep linked no matter if I add a row or a column in the spreadsheets, no matter if the cell change position. If there is a video would be perfect. Thanks for your time, greetings from Athens-Greece

[hazchickgames]

Honestly, I've just been making the data table at the bottom of excel sheets (CTRL+Arrow keys) to move to very bottom or just fomatting the text as white :/

[timon]

Good one! Another one for a similar topic. If you use Power Query as database for a chart, the custom chart formation might get removed whenever a refresh does not include this exact data. F. e. you color the sales for northeast region of a bar chart in grey. When 'northeast' is missing in any refreshed data the color format goes missing for the next time it is included. You can solve that by using dummy data entries in PQ. :)