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