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

Viewed 28

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.

line graphs here

1 Answers

Go to the pivot table and click edit go to Rows > order > ascending

enter image description here


enter image description here

Related