使用以下代码,如何设置格式,以便在图表中以货币值(货币值)显示CurrencyValue1和CurrencyValue2？
- function drawChart() {
- var data = new google.visualization.DataTable();
- data.addColumn('date','Date');
- data.addColumn('number','CurrencyValue1');
- data.addColumn('number','CurrencyValue2');
- data.addRows(1);
- data.setValue(0,new Date(2011,8,12));
- data.setValue(0,1,300.0000);
- data.setValue(0,2,759.1707);
- var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
- chart.draw(data,{ width: 660,height: 470,title: 'Heading',is3D: true,backgroundColor: '#f5f3e5' });
- }
解决方法
见文档：
http://code.google.com/intl/cs-CZ/apis/chart/interactive/docs/reference.html#numberformatter
- var data = new google.visualization.DataTable();
- data.addColumn('date','Date');
- data.addColumn('number','CurrencyValue1');
- data.addColumn('number','CurrencyValue2');
- var formatter = new google.visualization.NumberFormat(
- {prefix: '$',negativeColor: 'red',negativeParens: true});
- formatter.format(data,1);
- formatter.format(data,2);
这将格式列第二和第三列,如金钱(以美元符号为前缀“$15.00”)
