Bubble Chart values not displaying commas

33 views
Skip to first unread message

asingular

unread,
Mar 8, 2016, 7:24:36 PM3/8/16
to Google Visualization API
Hi all,

I am using the first example on this page: https://developers.google.com/chart/interactive/docs/gallery/bubblechart. It is working great but the numbers in the Population field are not displaying commas. I am connecting to SQL server and looping through using a Coldfusion query. Does anyone know why the commas are not displaying and what I can do to fix it?

Thanks so much!
Joe

Daniel LaLiberte

unread,
Mar 9, 2016, 8:34:42 AM3/9/16
to Google Visualization API
Hi Joe,

Can you point us at your example so we can see what you are doing?  I would suspect your data is strings rather than numbers.

--
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 google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/704d60fa-4560-4718-814d-6d682919d7f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

asingular

unread,
Mar 9, 2016, 4:41:13 PM3/9/16
to Google Visualization API
Hi Daniel,

I can't provide my link because it is an intranet site. But I have uploaded a screenshot and here is a code snippet.

['#stateAbbrev#', #totClearances#, #mergedata2.totWY#, '#regionName#', #totStaff#]

#totClearances# is a ColdFusion output of a number field, not a string. Not sure why it is being treated as a string.

thanks again,
Joe

Daniel LaLiberte

unread,
Mar 9, 2016, 4:55:03 PM3/9/16
to Google Visualization API
Hi Joe,

We would need to see some of your data to tell how it is formatted.    But assuming it's all fine, another problem is that we did fix some formatting problems a while ago, so to use the latest version, you might have to change the way you load charts as described here:  https://developers.google.com/chart/interactive/docs/basic_load_libs#update-library-loader-code

--
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 google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.

For more options, visit https://groups.google.com/d/optout.

asingular

unread,
Mar 10, 2016, 3:58:33 PM3/10/16
to Google Visualization API
Thanks Dan. Updating to the latest version did the trick. Appreciate the help.


On Tuesday, March 8, 2016 at 7:24:36 PM UTC-5, asingular wrote:
Reply all
Reply to author
Forward
0 new messages