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
cipriano555Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I may be missing something but it looks OK to me. Specifically which graph point is out of order?
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
cipriano555Author Commented:
January, March, May is in order???  No, should be January, February, March, etc.

The table is fine, the line graph is not.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
> "January, March, May is in order???  "

yes, because not all the points are labeled.  There is not enough space to show all the months.  You could stretch it wider and use a smaller font to see more labels.

You could also display the legend at the top or bottom to have more horizontal space

You could also format numbers on the Y-axis in millions to have more horizontal space.
to do that, in a format code, enter 2 commas at the end (for the data that feeds the chart or for the format of the axis).  For instance --> $#,##0.00,,

then make the title --> Total in Millions

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.