Pivot Graph dates are not ordered correctly

[Goose_RK]

Pivot graph is not ordered chronologically. How do I go about solving this?

Example of formula for date: =MONTH(D2) & "/" & DAY(D2) & "/" & YEAR(D2) & " - " & TEXT(D2,"ddd")

I've attached a screenshot of what the graph looks like.

[Neil_]

Your formula is converting dates into text, so it is sorting it correctly, alphabetically. You must the leave the data as dates if you want it sorted in date order. use custom formatting on the cell to get the date format you need instead of using formulas.

[Neil_]

Once you have changed the data series back to dates and got rid of the formula you entered, right click on the data, format cells, choose custom and enter this in the 'sample' text box.

mm/dd/yyyy - ddd