graph - Creating Stacked Bar charts in SSRS -

i create stacked barchart in ssrs.

i have following data.

id  year value 1  2005  990 1 2006 888 2 2005 986 2 2006 875 3 2005 970 3 2006 865 

i these 3 ids displayed in same bargraph, years stacked particular entity (based on ids). number of years same.

something below:

year 1  year 2           year 1 year 2     year 1 year 2 entity 1                  entity 2          entity 3        

i tried finding solution online not find related it.

can please help. lot.

you can add row_number dataset query , drag id , row_number fields category groups. id @ top of category group. change row_number group label year field. expected result.