Home > Enterprise >  How do I get my dates to sort chronologically in my google sheets line graph?
How do I get my dates to sort chronologically in my google sheets line graph?

Time:09-19

I am trying to create a line graph showing sales over time, but the dates are not in order. I have two line graphs, one by the date, and another by a variable I created with month and year. I don't want to sort the raw data using the menu, it is already sorted by order # and needs to stay that way. I would rather use a function if necessary. I have validated the date format for both date types using the DATEVALUE() function.

enter image description here


enter image description here

  • Related