谷歌图表轴线没有得到

问题描述:

目前我使用谷歌的图表,以显示我的.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它...

http://chart.apis.google.com/chart?cht=bvs&chs=500x300&chd=t:50,60,80,40,20,40,30&chxt=x,y&chxl=0%3a|A|B|C|D|E|F|G&chdl=A%3DStupidTest1|B%3DStupidTest2|C%3DStupidTest3|D%3DStupidTest4|E%3DStupidTest5|F%3DStupidTest6|G%3DStupidTest7

有两种可能的解决办法,我知道的,但两者的解决方案规定水平几个月值是连续的 - 意味着它应该将数据列类型设置为以下之一:数字,日期,日期时间或时间日期。你的字符串是月份列。

解决方案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

+0

首先thanx您reply.But上面的代码可贵的是从SQL server.In只是样品coe.I我retriving数据,我可能会得到个月一月,二月,三月...等或我可以得到第一列中的Grade1,Grade2,Grade3值。在那塞纳里奥我怎样才能得到垂直轴线到我的图表。 –

+0

就像我说的那样,字符串值是不可能的。您需要提供示例数值,然后可以使用某些格式。另一个解决办法是自己绘制垂直轴 – codebusta

+0

您可以使用重叠绘制自己的垂直线!如果你给我适当的例子,你会使用,我可以找出解决方案,直到那个,我的答案是正确的! – codebusta