Hi
I solved the previous issue by using the settings under Axis -> Scale -> Numeric Tab -> Step Mode "custom" -> Custom Step "Year". (only saw your reply recently, so apologies).
I have another issue you may be able to help with. I'm still using the xy scatter and grouping on effective date to give the following graph:
with these settings:
The problem is the space before the 2011 label. This happens because the data starts late in the year and the step is by "year". The client wants the label next-to the y-axis with no space before. I've tried changing the custom step to "month", but then each month has it's own label:
I've also tried formatting the label with "=IIf(Month(Fields!EffectiveDate.Value) mod 12 = 0, "yyyy","")", but no success.
Any ideas?