Hi All,
I have a column of dates that I would like as format 'MMM YY/YY'. As an example it would be April 21/22. Which is the fiscal year 2021, (In the UK it runs form April to March). I can create it no problem, but only as text and set another column to give it its order. The problem I have is that because it is not in sequence the Zoom on the X axis won't appear.
I have scratched my head enough and think I'm beat. Can this be done or do I have to find another format? Any help is always very much appreciated. Thanks.
I have a column of dates that I would like as format 'MMM YY/YY'. As an example it would be April 21/22. Which is the fiscal year 2021, (In the UK it runs form April to March). I can create it no problem, but only as text and set another column to give it its order. The problem I have is that because it is not in sequence the Zoom on the X axis won't appear.
I have scratched my head enough and think I'm beat. Can this be done or do I have to find another format? Any help is always very much appreciated. Thanks.