Jump to content
We've recently updated our Privacy Statement, available here. ×

X- Axis Month for Jan 2020

Anthony stark

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...