How to display zero in Line Chart ?

1. How do you show zeros on a line graph?
2. How do I insert a zero line in an Excel chart?
3. Do you include 0 in graph?

How do you show zeros on a line graph?

Click the chart you want to change. 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.

How do I insert a zero line in an Excel chart?

In your graph, double-click the target line. This will select the line and open the Format Data Series pane on the right side of your Excel window. On the Format Data Series pane, go to Fill & Line tab > Line section, and select No line.

Do you include 0 in graph?

“Always extend the scale to include zero.”

I don't know anyone who would think that the chart on the left is “wrong”, or that the “corrected” chart on the right is better. Clearly, then, it's not always necessary to extend the scale to include zero.