Graph Showing Quantities of Multiple Categories for Multiple Years

by Joey Grant   Last Updated March 12, 2018 20:16 PM

I have three sets of data:

+--------+------+------+------+
| Apples |      |      |      |
+--------+------+------+------+
|        | 2016 | 2017 | 2018 |
| Jan    |   40 |   36 |   44 |
| Feb    |   38 |   57 |   68 |
| Mar    |   40 |   17 |   19 |
| Apr    |   27 |   49 |      |
| May    |   44 |   51 |      |
| Jun    |   36 |   74 |      |
| Jul    |   34 |   40 |      |
| Aug    |   10 |   38 |      |
| Sep    |   22 |   59 |      |
| Oct    |   62 |   61 |      |
| Nov    |   43 |   67 |      |
| Dec    |   49 |   75 |      |
+--------+------+------+------+

+---------+------+------+------+
| Oranges |      |      |      |
+---------+------+------+------+
|         | 2016 | 2017 | 2018 |
| Jan     |   23 |   31 |   46 |
| Feb     |   13 |   27 |   19 |
| Mar     |   23 |   23 |   43 |
| Apr     |   24 |   26 |      |
| May     |   17 |   34 |      |
| Jun     |   14 |   48 |      |
| Jul     |   15 |   22 |      |
| Aug     |    9 |   44 |      |
| Sep     |   35 |   51 |      |
| Oct     |   21 |   34 |      |
| Nov     |   32 |   54 |      |
| Dec     |   48 |   33 |      |
+---------+------+------+------+

+---------+------+------+------+
| Peaches |      |      |      |
+---------+------+------+------+
|         | 2016 | 2017 | 2018 |
| Jan     |   13 |   11 |   35 |
| Feb     |   11 |   13 |   21 |
| Mar     |   11 |   25 |   19 |
| Apr     |   12 |   31 |      |
| May     |   12 |   19 |      |
| Jun     |   11 |   29 |      |
| Jul     |    2 |   22 |      |
| Aug     |    0 |   32 |      |
| Sep     |   10 |   26 |      |
| Oct     |   12 |   20 |      |
| Nov     |    6 |   26 |      |
| Dec     |   14 |   40 |      |
+---------+------+------+------+

Is there an elegant way to show all of this data on a single graph? I want to show how this data is affected by month of the year.

I have created a timeline where each fruit is a single line and I highlight the month of interest for each year. However, I feel that some context is lost when the data is not stacked.

I realize that this may fall into a category of "too much data for one graph," but wanted to get some opinions before splitting it into three separate charts.



Related Questions


What tools were used to create these CSS / SVG charts?

Updated February 26, 2018 22:16 PM



Are google charts WCAG compliant?

Updated December 04, 2017 12:16 PM