string in Y axis

Jun 18, 2009 at 10:37 PM

Hi,

I wanted to have a graph based on the count of the items in a list per month.   To achieve this I created a custom column called "Group By Month" using a calculated field;

Here is the calculated field string;

=YEAR(Created)&"-"&CHOOSE(MONTH(DATEVALUE("1/"&MONTH(Created)&"/"&YEAR(Created))),"01 Jan","02 Feb","03 Mar","04 Apr","05 May","06 Jun","07 Jul","08 Aug","09 Sep","10 Oct","11 Nov","12 Dec")

This all works well.   When I put the ChartPart on the page it displays the right data in the graphic columns, but the Y axis text / labels includes the date year and month from the above calculated column with string;# in front of the text.

Here is an example;

string;#2009-06 Jun

How can I remove the string;# from the front of the Y axis.

I am using version 1 of the ChartPart.

Regards,

Grant.

Coordinator
Jun 20, 2009 at 9:46 PM

Hi,

these issues should be fixed in version 2.

/WW