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 have a new column with month numbers but struggling with the coding for this too...Any help is much appreciated. See below for my current data and graph.
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.
4 Replies
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.