I've uncovered the root cause -- your charts can't read dates as values, i.e., there isn't a format in the spreadsheet for the chart to recognize. it only offers numerical, %, $, and text.