Click OK to close the Hidden and Empty Cell Settings dialog box.
The Hidden and Empty Cell Settings dialog box. Excel displays the Hidden and Empty Cell Settings dialog box. Excel displays the Select Data Source dialog box. You can instruct the program how you want it to treat empty cells by following these steps: If a cell is empty, it could be for any number of reasons-the value isn't available, the value isn't important, or the value is really zero.
One area where Excel doesn't quite know what to do, however, is empty cells. When you create a chart from a data table, Excel does its best to translate the numeric values into data points on a chart, according to the specifications you provide.
