Forum Discussion
Graph by specific month order
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.
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