create pie chart with custom category from dataset
Hello All I have a question about creating a pie chart which needs custom categorizinf from the data set in SSRS2008 below is the table that will be used as source of pie chart. Task Title Task duration (# of weeks spent) Task 1 2 Task 2 5 Task 3 3 Task 4 7 Task 5 9 from the data set i need to set categories as below Category1: duration (Number of weeks) 1 - 4 Category2: duration (Number of weeks) 5 - 8 Categpry 3: duration (Number of weeks) 9 - 12 Then the # of task for each category will be the value for the pie chart. I need the help to set the custom category based on the # of weeks in duration column. and need to set custom legend diaplaying 'Shorter than 1 month' for category1 , 'Shorter than 2 months' for category2 and 'Shorter than 3 months' for category 3 Can anyone show me or give tips how i can accomplish this? Thank you in Advance
January 18th, 2011 10:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics