Post reply

Format Label of x axis-Line Chart

  • October 6, 2008 at 2:16 pm

    #213712

    Guys,

    I have a line chart,that has X axis values with the following

    Scale (Min: 1 & Max:12)

    Numeric or time-scale value ticked.

    The scale 1 to 12 refers to Month Jan -Dec,represented as Integer

    I would like to change int values on x axis to month name from Jan-Dec.

    How is this possible?

  • October 14, 2008 at 2:27 pm

    #884890

    You can use the monthname function then just take the left 3 characters

    =Left(MonthName(Fields!MonthField.Value),3)

    You might consider rotating the text as well

  • October 14, 2008 at 2:31 pm

    #884892

    I figured that out ..Thank You

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply