Should an Excel line chart show zero for a day when no report arrived?
TechnologyOur 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.