Line Chart

[Ankit1988]

Hi.  please find the Above Image and please let me know How can Possible Week 1, week 2, week 3, Week 4, Week 5.

I have a Date field in data set and with help of this date field I create Week field and this Week field is Use in Line Chart its results shows week values is display like (1 to 53) Instead of we get . Week 1, week 2, week 3, Week 4, Week 5.

thanks

[G3S]

you can use Weekstart and weekend functions. and combine with the week number.

='Week '&WeekField&chr(10)&weekstart(DateField) &'-'&weekend(DateField)

chr(10) is to have the date in a separate line. if you want the month to be spelled out, you can wrap weekstart and weekend expressions with DATE function.