Charting Question

[Lhuffst]

I am not even sure how to pose the question but here goes.
I need a chart that shows 3 columns
1 - Tasks completed in current year (labeled completed)
2 - Tasks to be completed in current year (labeled 2012 Completion)
3 - Tasks to be completed in the next year (labeled 2013 Completion)

The data is
Early End Date (4 digit year of expected end date)
Status_Code = tk-Completed, tk-Not Started or tk-Active

My intent was to have the column marked
completed match to tk-completed
2012 completion match to tk-active
2013 compeltion match to tk-notStarted.

I have tried this a couple of way.

1. I made groups yearend and status code so the data groups correctly.
This charts but puts the order of the bars as 2013-completion, 2012-completion and completed. I need it the exact opposite.

2. I created a formula that conconated the year and the word completed or completion (nested if statement) and used that as my group but had the same result.

3. I tried to do specified order but that didn't work either.

Now I don't know what to try.

My data tab has
On change of Yearenddate
--------------------------
Show Values
Count Status Code summary

Any suggestions Anyone?

 

[Lhuffst]

Update: I managed to get the columns in the correct order by creating the following formula.

If {Command.STATUS_CODE} = "TK_Active" then "b"
else if {Command.STATUS_CODE} = "TK_NotStart" then "c"
else if {Command.STATUS_CODE} = "TK_Complete" then "a"

What I need to do now is change the
"a" to "completed"
"b" to current year + "completion"
"c" to (Current Year + 1) + "completion"

I know I can put a label over this but I dont' want to have to change the label each year. How would I do this in a chart and have it display the correct values automatically?
Thanks
Lhuffst