Display Google Chart Title in Chinese

[CPU Lawrence]

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.

The following Google Chart display the same title in HTML code instead of Unicode "港股羅庚作品‧Ali 指標"

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: '&#28207;&#32929;&#32645;&#24218;&#20316;&#21697;&#8231;Ali &#25351;&#27161;',

          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

[Daniel LaLiberte]

The language setting should support zh-hk.  Have you tried it with all lowercase, rather than zh-HK?  Not sure that should matter, but worth a try.

Also, I would recommend you use the new loader if possible.  Here are the instructions: 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-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@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/8e0a8fca-6297-450c-98a1-2d80f7bc0706%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA

[Daniel LaLiberte]

I should have looked closer at your code before responding.  Actually, the language setting doesn't affect how your title text is rendered.  There is certainly no translation of the text, which is what the language setting is intended for, and there is nothing special about rendering characters corresponding to html entities.  The problem is how to specify the right characters such that when rendered in the svg for the chart, it looks correct.  I am not sure about what HTML entities would work as you expect, but the page you linked to by Shun Nien has title properties like this:

  title: '長條圖',

And when I copy-paste that text in my chart, I see the same characters.

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visualization-api@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/8e0a8fca-6297-450c-98a1-2d80f7bc0706%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA