Anthony stark Posted January 3, 2020 Share Posted January 3, 2020 Hi Experts , I have a line chars with the x-Axis limited with the following expression: [DATE]>=dateadd('mm',-6, Date TimeNow()), and the data source is an excel spreadshhet that is updated with data manually. The problem is, when i updated the data with today/ january data, the Current month (January) is now before the other months on the X-axis. How do i get the January data to come after decemember, and not before july Currently the X-axis is: Jan, July, Aug, Sep,Oct,Nov, Dec. July - Dec are all 2019 data, and January is 2020 data, how do i get the january 2020 data to come after the Dec 2019 data on the x-axis Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted January 6, 2020 Share Posted January 6, 2020 You would need to append year as well in your x-axis so Jan2020 comes after Dec2019. If you simply custom sort jan after dec then when dec 2020 arrives Jan 2020 will appear after dec. You can add Year NEST Month in your x-axis, then pull the X-Axis labels line downwards so year gets hidden and months are aligned accordingly. Attaching the screenshot for reference Link to comment Share on other sites More sharing options...
Anthony stark Posted January 6, 2020 Author Share Posted January 6, 2020 Thanks Khushboo, this worked Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now