cancel
Showing results for 
Search instead for 
Did you mean: 

Month name instead of month number in X axis

Former Member
0 Kudos

My X axis shows monthnumber/year, but I want it as Monthname/year (May/2012) or Monthname-Year (May-2012). None of my x and y axis data are coming from formula field. Can someone help. I am using CR Xl.

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Brian,

Here's a method that shows the dates in the format you want and also sorts them in the right order:

1) Insert a Crosstab and place it on the Report Header. Use the date field as the row and the measure field as the Summary field.

2) While in the Crosstab Expert, highlight the field in the Row > Click Group Options > Options  tab > check the option 'Customize Group Name field' > Select 'use formula as group name' and click the formula button beside. Use this code:

totext({date_field},"MMMM-yyyy")

4) Right-click the Crosstab and select Insert Chart. Choose the right Chart Type

5) Suppress the Section that holds the Crosstab

Hope this helps.

-Abhilash