I am using a line chart created with data imported from a table (table_1) in MySQL. To render the graph as I want it I use a cross table statement.
It works nicely.
The remaining thing to improve now are the labels. The MySQL data base has the proper labels stored in another table (table_2), hence in the graph when it takes the labels from the attribute used as the dimension I get a number, whereas in table_2 the prober label is a text-string.
Is there a way for me to replace the labels in the line chart to get proper labels for the attributes?