Forum Discussion
Graph by specific month order
Hi guys, I have watched a lot of videos and tried to follow online guidance on here but I still can't seem to get my graphs to order in financial year order (April first). I understand I need to...
Easy as:
1. Enter Data - copy and paste this table
Month Financial Order January 10 February 11 March 12 April 1 May 2 June 3 July 4 August 5 September 6 October 7 Novermber 8 December 9 1.5 - In the Data view, click on your new Month column, Sort Column By - "Financial Order
2. In your Model View - link the two Months columns - bidirectional one to many relationship.
3. In your chart, drag the Months from your new table as the x axis.
Hi Len,
Thanks for your help. For some reason it is dispalying as not valid. Any ideas?
Anonymous Got it, I accidentally had them linked to other columns in model view.
Now I believe I have everything as you have said...but still no luck with graph. Any ideas?
Got it as I want it now👍 Thanks for yur help Anonymous