Excel understands units of time -- days, weeks, months, years. But there doesn't seem to be an easy way to tell it "this data is monthly and that data is quarterly" even though the dates are right there next to the data in the spreadsheet. At least I couldn't make it work.
It suddenly occurred to me that if you think of the dates as just numbers, Excel would know how to graph them. If the dates are just values, excel can match up January with the First Quarter, and April with the Second Quarter, and it will know that February and March go in between the First and Second Quarters. I think that's what's going on.
Excel understands units of time -- days, weeks, months, years. But there doesn't seem to be an easy way to tell it "this data is monthly and that data is quarterly" even though the dates are right there next to the data in the spreadsheet. At least I couldn't make it work.
ReplyDeleteIt suddenly occurred to me that if you think of the dates as just numbers, Excel would know how to graph them. If the dates are just values, excel can match up January with the First Quarter, and April with the Second Quarter, and it will know that February and March go in between the First and Second Quarters. I think that's what's going on.
Anyway, I did it, and it worked.