javascript - Google Charts Y 轴未排序

Question

我尝试在我的一个项目中使用 Google 图表。一切都工作得很好，但我的 Y 轴完全未排序。

这是我用来显示图表的实际代码:

    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
    google.charts.load('current', { 'packages': ['corechart', 'bar'] });

    google.charts.setOnLoadCallback(function () {
        var title = 'Total Sales By Market and Year';
        var subtitle = 'Cincinnati, Cleveland, Columbus, and Dayton';
        var dataTable = new google.visualization.DataTable(
            {"cols":[{"label":"UsageDates","type":"string"},{"label":"C1","type":"string"},{"label":"C2","type":"string"},{"label":"C3","type":"string"},{"label":"C4","type":"string"}],"rows":[{"c":[{"v":"14.06.2016"},{"v":0},{"v":0},{"v":6},{"v":7}]},{"c":[{"v":"15.06.2016"},{"v":50},{"v":0},{"v":0},{"v":0}]},{"c":[{"v":"16.06.2016"},{"v":0},{"v":13},{"v":1},{"v":3}]},{"c":[{"v":"20.06.2016"},{"v":5},{"v":7},{"v":0},{"v":0}]}]}
        );

        drawBarChart('chart_div', title, subtitle, dataTable);
        //drawColumnChart('chart', title, dataTable);
    });

    function drawColumnChart(elementId, title, dataTable) {
        var options = {
            title: title,
            vAxis: { format: 'decimal' }
        };
        var chart = new google.visualization.ColumnChart(document.getElementById(elementId));
        chart.draw(dataTable, options);
    }
</script>

结果看起来有点奇怪，我认为 Y 轴的值没有排序，而是在输入时取值。 我希望有人能帮助我解决这个问题。

Answer 1

尝试将 C1..C4 的 cols 定义从“字符串”更改为“数字”，以匹配您提供的数据。

"cols":[{"label":"UsageDates","type":"string"},{"label":"C1","type":"number"},{"label":"C2","type":"number"},{"label":"C3","type":"number"},{"label":"C4","type":"number"}]

Codepen example