I have a time series grid for which there will be sparse data, as changes won't happen often, as shown:
I'm wondering what the best way to display cells when there haven't been any changes is. The '-' could be confused for a null or zero value, but displaying the same number makes months with changes less visually striking. Are there any commonly used solutions to this?
I Should clarify. The '-' here doesn't represent 0. The 'Bar' row contains (5, 5, 6, 6, 6, 6). The user can edit a value, and this table will show what that value was for each month. The issue is that the first 5 represents an actual record in a database, but the user didn't change that value in February, so there is not another record until March. If this isn't a common use case, I'll do as Michael Lai suggested and show data for all cells, but highlight changes somehow.