How can I visualize that data for a cell is not applicable?

1. How do you show missing data on a graph?

How do you show missing data on a graph?

Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Click Hidden and Empty Cells. In the Show empty cells as: options box, click Gaps, Zero, or Connect data points with line.