Link to home
Start Free TrialLog in
Avatar of narmi2
narmi2

asked on

Google Chart corechart help

Dear Experts,

I have the following json structure, which can be formatted to a named style json structure if need be:

[
{"User1":{"v":10,"f":"£20"}},
{"User2":{"v":20,"f":"£40"}},
{"User3":{"v":20,"f":"£40"}},
{"User4":{"v":30,"f":"£60"}},
{"User5":{"v":20,"f":"£40"}}
]

I am trying to get this into the following javascript google chart

data.addRows(5);  
data.setValue(0, 0, 'User1');  
data.setValue(0, 1, 20);  
data.setValue(1, 0, 'User2');  
data.setValue(1, 1, 40);  
data.setValue(2, 0, 'User3');  
data.setValue(2, 1, 40);  
data.setValue(3, 0, 'User4');  
data.setValue(3, 1, 60);  
data.setValue(4, 0, 'User5');  
data.setValue(4, 1, 40);  

Which works if I do this:

data.addRows(json.length);
for(var j in json) {
      for(var k in json[j]) {
            data.setValue(parseInt(j), 0, k);
            data.setValue(parseInt(j), 1, parseInt(json[j][k].f.substring(1)));
      }
}

How do I get it to display the "£" sign too, next to the "f" value, for display purposes only?

Please help

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Michel Plungjan
Michel Plungjan
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of narmi2
narmi2

ASKER

Another chart type did the trick!
Avatar of narmi2

ASKER

The barchart, and column charts I have tried so far.  Plus you can att the £ sign in the legend section of the piechart using
var formatter = new google.visualization.NumberFormat({prefix: ''});
formatter.format(data, 1);
 However, I couldn't get it into the mouseover popups for some reason using the above script.