Jul 23, 2001 #1 dhanson IS-IT--Management Dec 10, 2003 9 US I have a chart that has its X axis based on quarterly numbers. Right now the chart sorts the quarters like this: Q1 2000 Q1 2001 Q2 2000 Q2 2001 ect. How can I get it to sort it ascendingly? Q1 2000 Q2 2000 Q1 2001 Q2 2001 ect.
I have a chart that has its X axis based on quarterly numbers. Right now the chart sorts the quarters like this: Q1 2000 Q1 2001 Q2 2000 Q2 2001 ect. How can I get it to sort it ascendingly? Q1 2000 Q2 2000 Q1 2001 Q2 2001 ect.
Jul 23, 2001 #2 DougP MIS Dec 13, 1999 5,985 US Text is always a problem It sorts down an entire column then to the next column Q1 2000 Q1 2001 Q2 2000 Q2 2001 you could add a Number field to the table like so and sort on it instead index Quarter year 1 Q1 2000 2 Q2 2000 3 Q3 2000 4 Q4 2000 5 Q1 2001 DougP, MCP Visit my WEB site http://www.barcodeone.com to see how Bar-codes can help you be more productive Upvote 0 Downvote
Text is always a problem It sorts down an entire column then to the next column Q1 2000 Q1 2001 Q2 2000 Q2 2001 you could add a Number field to the table like so and sort on it instead index Quarter year 1 Q1 2000 2 Q2 2000 3 Q3 2000 4 Q4 2000 5 Q1 2001 DougP, MCP Visit my WEB site http://www.barcodeone.com to see how Bar-codes can help you be more productive