Hi,

I am trying to setup a chart that has the previous 18 months and trying to compare to the projected 6 months. Since I have 2 years on one graph I want to compare it month to month. Right now I just have the x-axis numbered 1 to 12. Is there some way I can truncate the "Oct-12" (date data type) to just look like "Oct" on the graph with October of 2011 and October of 2012 on the same x-coordinate?

Attached is a snap of the graph with the green being 18 months ago to 7 months ago and the yellow is 6 months ago to 1 month ago and the red being the projected 6 months. Let me know if anybody has any ideas.

SNAP.jpg