Web Viewer and Google Charts API

[flashkiwi]

Hi

 

I want to use Web Viewer to view charts created by Google Charts API.

 

I am strugging to work out how to insert fields (data1 and data2) into the following URL so I can create a chart based on the live data set.

 

http://chart.apis.google.com/chart?cht=p3&chd=t:60,40&chs=250x100&chl=Hello|World

 

I want to replace ....chd=t:60,40 with chd=t:data1, data2

 

I have tried " & table1::data1 & " and various other combinations with no luck.

 

I have seen other solutions that use the Let () statement but think that may be overkill.

 

If someone could point me in the right direction on how to solve this it would be much appreciated.

 

Best regards

Greg

[AHunter3]

http://chart.apis.google.com/chart?cht=p3&chd=t:60,40&chs=250x100&chl=Hello|Wor ld

 

I want to replace ....chd=t:60,40 with chd=t:data1, data2

 

"http://chart.apis.google.com/chart?cht=p3&chd=t" & YourTable::data1 & "," & YourTable::data2& "&chs=250x100&chl=Hello|World"

[flashkiwi]

"http://chart.apis.google.com/chart?cht=p3&chd=t" & YourTable::data1 & "," & YourTable::data2& "&chs=250x100&chl=Hello|World"

 

Excellent - I knew it would be that easy. Thanks for your prompt assistance.

 

Greg