How do I represent null values in a line chart?

1. How do you display NULL data?
2. How do you represent no data on a graph?
3. How do you show zeros on a line graph in Excel?

How do you display NULL data?

Display of Null Values. The Display Null Values field allows you to specify how your report presents null values. Depending on the data definition of the underlying table, a null value can be left blank or printed as some special value. The default is to simply leave null values as blanks on the report.

How do you represent no data on a graph?

In all graph types (bar, line, or area), missing values appear as a gap in the graph. Dotted line to zero. In line graphs, a dotted line connects the missing value with the succeeding value.

How do you show zeros on a line graph in Excel?

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.