cipriano555
asked on
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
Martin Liss
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
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.