You can't use the object notation for cells when using the arrayToDataTable method - it is unsupported, as you see when you try to use that in the first row. You can either build the DataTable manually and then pass the rows in using the object notation, or you can enter just the values using arrayToDataTable and use a NumberFormatter to handle the formatting for you.
Manual DataTable: http://jsfiddle.net/asgallant/FN36W/54/ NumberFormatter: http://jsfiddle.net/asgallant/FN36W/55/ On Friday, July 19, 2013 6:18:02 PM UTC-4, TheInnovator wrote: > > Hi All, > > I used Google charts to visualize my data into a table and it worked. The > last column is where the issue is. I am trying to format the last column > as currency(prefix with '$'), which works except for the last column in the > first row. Though I applied the same format, it bombs on me. > > Here's a working jsfiddle of it and as you will see the last columns of > 'Org2' and 'Total' are prefixed with the '$' sign but the first one isn't. > > http://jsfiddle.net/FN36W/51/ > > In the following jsfiddle, the table bombs when I apply the prefix to the > last column of the first row. > > http://jsfiddle.net/FN36W/52/ > > Can somebody please explain why that is and how to correct it? > > Thanks! > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
