My project has hundreds of Google Sheets that have the same data schema, and one of the requirements is to create the same set of 6 charts on each sheet. I'm using Google Chart for online publishing. Since the target audiences are Chinese, the Google Chart's title needs to be in Chinese.
The following chart is embedded in Google Sheet, and has the title in Chinese. <https://lh3.googleusercontent.com/-gUQNeTEBaOE/V9LV4RxOgMI/AAAAAAAAAjo/udih8_pDarYvkfO134lbBDWRaBC5_6zyQCLcB/s1600/CPU-16-09-09a.png> The following Google Chart display the same title in HTML code instead of Unicode "港股羅庚作品‧Ali 指標" <https://lh3.googleusercontent.com/-ckjMx0-gZII/V9LXmYZ41YI/AAAAAAAAAjw/JwyGc-tU_uQNd4PdTbq09Jkcsbt74RfCQCLcB/s1600/CPU-16-09-09b.png> The following is part of my source code: <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> //google.load("visualization", "1", {packages:["corechart"]}); google.load('visualization', '1.1', { 'packages': ['corechart'], 'language': 'zh-HK' }); google.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ... ]); var options = { title: '港股羅庚作品‧Ali 指標', titleTextStyle:{ color: 'blue', fontSize: 18 }, smoothLine: true, backgroundColor: { stroke: '#000000', strokeWidth: 1}, legend: {position: 'none'}, I tried Shun Nien's proven work on https://dotblogs.com.tw/shunnien/2014/02/21/144107. No luck. Hope someone in this community can give me a lift. Thank you -- 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 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/8e0a8fca-6297-450c-98a1-2d80f7bc0706%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
