Smart questions
Smart people
 Find A ForumFind An Expert
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Remember Me

Are you a
Computer / IT professional?
Join Tek-Tips now!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Just copy and paste the

#### Feedback

"...This site is awesome!...Things I have been trying to figure out for weeks, I got the answer in hours!..."

#### Geography

Where in the world do Tek-Tips members come from?

# Problem With Bar Order on Bar Chart

 Forum Search FAQs Links Jobs Whitepapers MVPs
 kernal (TechnicalUser) 30 Apr 12 14:18
 I have a grouping Age and then Fiscal Year but the sorting is not correct on the bar chart and the only thing I can figure is because there is no data for ages 12 and under in fiscal year 2009-2010. There are data for ages 12 and under in fy 2010-2011 and all of the other age groups has data for both fiscal years.I have the bar chart on change of age group then fiscal year group.AGE GROUP sorted in ascending orderifage<=12then'12 and under'else ifage in 13 to 18then'13 to 18'else ifage in 19 to 49then'19 to 49'else ifage>=50then'50 and over'FISCAL YEAR GROUP sorted in ascending orderif add_date in date(2009,07,01) to date(2010,06,30)then'2009-2010'else ifadd_date in date(2010,07,01) to date(2011,06,30)then'2010-2011'AGE RESULTS12 and underno data for fy 2009-20101 for fy 2010-201113 to 18100 for fy 2009-2010106 for fy 2010-2011etc.PROBLEMMy bar chart shows the ages 12 and under for fy 2010-2011 as 1; ages 13 to 18 and other groups are showing 2010-2011 first so for ages 13 to 18, the first bar has 106 then the second bar 100 for this age group.I need the first bar to have the fy 2009-2010 data then the second bar to have the 2010-2011 data.I hope I gave enough information. Help is very appreciated.thank you

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!