谷歌图表轴线没有得到
问题描述:
目前我使用谷歌的图表,以显示我的.NET Web application.I报告使用谷歌的组合图表时许,列charts.Here是我使用的示例代码。谷歌图表轴线没有得到
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawVisualization);
function drawVisualization() {
// Some raw data (not necessarily accurate)
var data = google.visualization.arrayToDataTable([
['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua New Guinea', 'Rwanda', 'Average'],
['2004/05', 165, 938, 522, 998, 450, 614.6],
['2005/06', 135, 1120, 599, 1268, 288, 682],
['2006/07', 157, 1167, 587, 807, 397, 623],
['2007/08', 139, 1110, 615, 968, 215, 609.4],
['2008/09', 136, 691, 629, 1026, 366, 569.6]
]);
var options = {
title : 'Monthly Coffee Production by Country',
vAxis: {title: 'Cups'},
hAxis: {title: 'Month'},
seriesType: 'bars',
series: {5: {type: 'line'}}
};
var chart = new google.visualization.ComboChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
在i执行此代码我正在歌厅的水平网格线,但我想一个垂直网格线也从“0”开始position.I想垂直网格线像下面URL(图象)中所示。如何我可以通过使用谷歌appriciated可视化API.Your帮助WIL acheive它...
答
有两种可能的解决办法,我知道的,但两者的解决方案规定水平几个月值是连续的 - 意味着它应该将数据列类型设置为以下之一:数字,日期,日期时间或时间日期。你的字符串是月份列。
解决方案1 - 使用的数值为一个月,你可以使用日期和格式化与hAxis: '一些日期格式',并使用基线:0
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawVisualization);
function drawVisualization() {
// Some raw data (not necessarily accurate)
var data = google.visualization.arrayToDataTable([
['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua New Guinea', 'Rwanda', 'Average'],
[1, 165, 938, 522, 998, 450, 614.6],
[2, 135, 1120, 599, 1268, 288, 682],
[3, 157, 1167, 587, 807, 397, 623],
[4, 139, 1110, 615, 968, 215, 609.4],
[5, 136, 691, 629, 1026, 366, 569.6]
]);
var options = {
title : 'Monthly Coffee Production by Country',
vAxis: {title: 'Cups', gridlines:{count:3}},
hAxis: {title: 'Month', baseline:0},
seriesType: 'bars',
series: {5: {type: 'line'}}
};
\t
\t
var chart = new google.visualization.ComboChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
解决方案2 - 在这里也用数值为一个月,但此时使用蜱:[{v:0}]
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawVisualization);
function drawVisualization() {
// Some raw data (not necessarily accurate)
var data = google.visualization.arrayToDataTable([
['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua New Guinea', 'Rwanda', 'Average'],
[1, 165, 938, 522, 998, 450, 614.6],
[2, 135, 1120, 599, 1268, 288, 682],
[3, 157, 1167, 587, 807, 397, 623],
[4, 139, 1110, 615, 968, 215, 609.4],
[5, 136, 691, 629, 1026, 366, 569.6]
]);
var options = {
title : 'Monthly Coffee Production by Country',
vAxis: {title: 'Cups', gridlines:{count:3}},
hAxis: {title: 'Month', ticks: [{v:0}]},
seriesType: 'bars',
series: {5: {type: 'line'}}
};
\t
\t
var chart = new google.visualization.ComboChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
\t
\t
\t
首先thanx您reply.But上面的代码可贵的是从SQL server.In只是样品coe.I我retriving数据,我可能会得到个月一月,二月,三月...等或我可以得到第一列中的Grade1,Grade2,Grade3值。在那塞纳里奥我怎样才能得到垂直轴线到我的图表。 –
就像我说的那样,字符串值是不可能的。您需要提供示例数值,然后可以使用某些格式。另一个解决办法是自己绘制垂直轴 – codebusta
您可以使用重叠绘制自己的垂直线!如果你给我适当的例子,你会使用,我可以找出解决方案,直到那个,我的答案是正确的! – codebusta