If you are facing a problem that your Excel charts disappear when you hide the columns showing the data. In this article, we will show you how to stop excel charts from disappearing. Follow these simple steps :
STEP 1: Click anywhere on the chart and from the ribbon
STEP 2: Select Chart Tools > Design > Select Data
STEP 3: In the “Select Data Source” dialogue box, select “Hidden and Empty Cells”
STEP 4: Now select the “Hidden and Empty Cell Settings” dialog box, click the box “Show data in hidden rows and columns”.
STEP 5: Select “OK”
