Apologies for not being very clear about what i want, but i'm sure this image will help

This is how i want to display my chart, using sql2000 my data was...

The problem is not displayin data, it is to to add this month in Reporting Services Charts, what i was trying to do is to group these month as one...

In SQL 2000 i solve using this code

Select FinYear, FinMonth, FinMonthNm,

Case When FinYear = '2007/08' Then AvgLoS End As AvgLoS200708,

Case When FinYear = '2008/09' Then AvgLoS ...