Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Charts: How to sort the X axis?

Status
Not open for further replies.

dhanson

IS-IT--Management
Dec 10, 2003
9
0
0
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.


 
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 to see how Bar-codes can help you be more productive
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top