What kind of graph is it? Line, bar, or ??
Are the numerous blank entries what you want here?
have you tried this expression:
HiCo Week1 + 0 &¶&
HiCo Week2 + 0 &¶&
HiCo Week3 + 0 &¶&
HiCo Week4 + 0 &¶&
HiCo Week5 + 0 &¶&
HiCo Week6 + 0 &¶&
To see if it makes any difference?
A line graph. I do need the blank entries there as it is a comparison span of 52 weeks. No I haven't, I will that.
EDIT: The 0's helped to format the field in view mode but I am still not getting any lines on the chart
Let's take a look at your chart options. Enter layout mode and double click the chart. Post a screen shot of the dialog that opens.
Well, I guess I figured it out. The problem was my x-axis value was only 1 value, it didn't span across to chart data points. I changed it to have multiple values and it works now