Microsoft Excel
--
Questions
--
Followers
Top Experts
Excel Graph does not use Chronological order for Dates.
Excel doesn't plot the line graph i chronological order = order of the data
Pivot table used
Table shows correct order, line graph does not.
So frustrating.
DatesNotPlottedInChrolonolgicalOrder.PNG
Pivot table used
Table shows correct order, line graph does not.
So frustrating.
DatesNotPlottedInChrolonolgicalOrder.PNG
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
I may be missing something but it looks OK to me. Specifically which graph point is out of order?
They look in order to me too ... but I do notice that the dates are not evenly spaced as the difference between Fiscal September, 2012 and Fiscal November, 2013 is the same as when they are just a few months apart.
This can be alleviated by pivoting actual dates and them formatting them to SHOW:
"Fiscal "mmmm, yyyy
This can be alleviated by pivoting actual dates and them formatting them to SHOW:
"Fiscal "mmmm, yyyy
January, March, May is in order??? Â No, should be January, February, March, etc.
The table is fine, the line graph is not.
The table is fine, the line graph is not.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.