Sorry, thought you were doing a bar chart.
Here is one way (although I do not know how elegant it is. (I am betting there is a much nicer approach but my brain is fried right now).
1. Create a formula called 'Week' as:
datepart('ww',{TICKET.REPORTDATE})
Create a group on this formula field.
Create a Running Total:
Name=2009
Field to summarize=field you want displayed on chart
Type of summary= you choose (noy sure if you are doing a count or a SUM)
Evaluate= use a formula
Year({TICKET.REPORTDATE})=2009
Reset=On change of group1
Create a second RT:
Name=2010
Field to summarize=field you want displayed on chart
Type of summary= you choose (noy sure if you are doing a count or a SUM)
Evaluate= use a formula
Year({TICKET.REPORTDATE})=2010
Reset=On change of group1
Create your chart type as Stacked Line Chart (with or without markers)
Data= On chaage of @Week
Show values = add both yuor RTs (#2009 and #2010)
Validate the data
Edited by DBlank - 25 Feb 2010 at 2:52pm