I have two data sets over the same span of time. One set has monthly data, and the other has yearly data. How can I show them on the same line chart?
I tried putting the yearly data with the monthly data, like this CSV:
Month, Monthly data, Yearly data
Jan 2000,1,1.2
Feb 2000,2,
Mar 2000,3,
...
Dec 2000,12,
Jan 2001,13,12.5
I couldn’t get the yearly data to show up on my line graph due to the missing data.
It’s actually already a pain to get the data in the format above. I would rather pull data from one sheet which is monthly and a second sheet that looks like this:
Year, Yearly data
1/1/2000,1.2
1/1/2001,12.5
1/1/2002,25.3