Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Should an Excel line chart show zero for a day when no report arrived?

Technology category photographTechnology

Our attendance chart drops to zero on Wednesday. The underlying Wednesday cell is genuinely empty because the report hasn't arrived; nobody has said that attendance was zero. My helper wants to fill the blank with 0 so the sheet agrees with the chart.

Microsoft documents chart settings for showing empty cells as gaps, zeros or a connecting line. Excel's empty-cell chart guidance

Should we change the display and label the missing report instead? I don't want a chart setting to turn an unknown count into an entry we later mistake for a recorded result.

Discussion

5 community replies

Keep the distinction between unknown and recorded zero. The chart's treatment of an empty cell doesn't supply the missing observation. Don't enter a zero merely to make the worksheet match a display choice.

For this line chart, inspect Select Data, Hidden and Empty Cells. Microsoft describes Gaps, Zero and Connect data points with line there. Choose deliberately rather than assume the shape you inherited reflects the meaning of the data.

A connecting line could look neater while still leaving the Wednesday count unknown. If the missing report matters to the reader, explain it instead of letting continuity suggest that you observed something you haven't.

Check the resulting chart alongside both an actual zero, if the data has one, and the missing Wednesday entry. They should communicate the different situations you intend people to understand.

Include that explanation in the chart version the group receives. An empty source cell won't help someone who sees only the image. A brief missing-report note can preserve the distinction without inventing an attendance figure.

Join the discussion

More in Technology