textfields not showing on x-axis

I am trying to make a basic dynamic chart work like this:

I have a MySQL database table with a column "ID", and a column "instrument"
I want the chart to display the number of rows per instrument, so I choose
"instrument" for the x-label and I choose Group by value.
For the Y value I choose "ID" and I also choose calculation count.
The only result I get is a blank chart where the x-axis has the labels 0-10 (nothing to do with the "instrument" column that i want to be there.)
I keep getting the same result as long as I choose a text field for the x-label.
But when I choose a numeric field for the x-label the chart gives back a correct result.
Doesn´t Dynamic web charts support text fields in dynamic charts?
This could not be the case or what?

/Jonas

The chart should work with text for the labels, can you send a link where i could see the problem to investigate the issue?

Thanks for your help!

Here´s a link to the page showing an empty chart with numbers on the x-axis, instead of the different instruments I want it to be there.

/Jonas

charttest.php

when i view the xml:
charttest_data1.php


I see that one of the lines has an accented character that is not displaying properly:
<label>Klassisk s&#65533;ng</label>



Does it show correctly ion the database?


If so try setting the connection to use the utf-8 character set.

In the connection file, locate the closing php tag:
?>


and add this code before it:

mysql_set_charset('utf8',$<your connection name>);

where <your connection name> is the name of your connection

That was the solution!

Now it works just fine.

Thank´s a lot for your help!

/Jonas

great, glad to hear it is working.