I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable:
I think there are two reasons for this:
- Not all dates have values associated with them, and therefore are not represented on the graph
- Zeroes are represented as blanks, and therefore are not represented on the graph.
To illustrate this, here is what my current data table looks like to build the above graph:
Sales Data ($):
Dates | Arugula | Bean | Beet | Broccoli | ...
10/21/2019 | 4 | | | | ...
10/19/2019 | | 20 | 5 | | ...
10/15/2019 | | | | 2 | ...
...
And here is what I think it should look like:
Sales Data ($):
Dates | Arugula | Bean | Beet | Broccoli | ...
10/21/2019 | 4 | 0 | 0 | 0 | ...
10/20/2019 | 0 | 0 | 0 | 0 | ...
10/19/2019 | 0 | 20 | 5 | 0 | ...
10/18/2019 | 0 | 0 | 0 | 0 | ...
10/17/2019 | 0 | 0 | 0 | 0 | ...
10/16/2019 | 0 | 0 | 0 | 0 | ...
10/15/2019 | 0 | 0 | 0 | 2 | ...
...
Given that I have about ~100 columns for each seed type, and about 500 dates currently, what is the best way to make my data table look more like the second example to make a better timeline chart?