Stacked bar chart re:Data Value Markers

[Todlerone]

Hello all and TY in advance for any help/suggestions. I have
successfully added a stacked bar chart with Data Value Markers,
however, for the life of me I can't seem to get rid of an extra row of
"0''s that have appeared.


Here is my code.....and again TY.

<script type="text/javascript">
var queryString = '';
var dataUrl = '';

function onLoadCallback() {
if (dataUrl.length > 0) {
var query = new google.visualization.Query(dataUrl);
query.setQuery(queryString);
query.send(handleQueryResponse);
} else {
var dataTable = new google.visualization.DataTable();
dataTable.addRows(140);

dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');
dataTable.addColumn('number');

dataTable.setValue(0, 0, 0);
dataTable.setValue(0, 1, 8);
dataTable.setValue(0, 2, 1);
dataTable.setValue(0, 3, 1);
dataTable.setValue(0, 4, 0);
dataTable.setValue(0, 5, 0);
dataTable.setValue(0, 6, 0);
dataTable.setValue(0, 7, 3);
dataTable.setValue(0, 8, 0);
dataTable.setValue(0, 9, 0);

dataTable.setValue(1, 0, 0);
dataTable.setValue(1, 1, 12);
dataTable.setValue(1, 2, 0);
dataTable.setValue(1, 3, 4);
dataTable.setValue(1, 4, 0);
dataTable.setValue(1, 5, 0);
dataTable.setValue(1, 6, 0);
dataTable.setValue(1, 7, 4);
dataTable.setValue(1, 8, 0);
dataTable.setValue(1, 9, 0);

dataTable.setValue(2, 0, 0);
dataTable.setValue(2, 1, 37);
dataTable.setValue(2, 2, 0);
dataTable.setValue(2, 3, 5);
dataTable.setValue(2, 4, 0);
dataTable.setValue(2, 5, 0);
dataTable.setValue(2, 6, 0);
dataTable.setValue(2, 7, 4);
dataTable.setValue(2, 8, 1);
dataTable.setValue(2, 9, 0);

dataTable.setValue(3, 0, 0);
dataTable.setValue(3, 1, 13);
dataTable.setValue(3, 2, 1);
dataTable.setValue(3, 3, 2);
dataTable.setValue(3, 4, 0);
dataTable.setValue(3, 5, 0);
dataTable.setValue(3, 6, 1);
dataTable.setValue(3, 7, 2);
dataTable.setValue(3, 8, 0);
dataTable.setValue(3, 9, 0);

dataTable.setValue(4, 0, 0);
dataTable.setValue(4, 1, 21);
dataTable.setValue(4, 2, 0);
dataTable.setValue(4, 3, 0);
dataTable.setValue(4, 4, 0);
dataTable.setValue(4, 5, 1);
dataTable.setValue(4, 6, 0);
dataTable.setValue(4, 7, 0);
dataTable.setValue(4, 8, 0);
dataTable.setValue(4, 9, 0);

dataTable.setValue(5, 0, 0);
dataTable.setValue(5, 1, 22);
dataTable.setValue(5, 2, 0);
dataTable.setValue(5, 3, 3);
dataTable.setValue(5, 4, 0);
dataTable.setValue(5, 5, 0);
dataTable.setValue(5, 6, 1);
dataTable.setValue(5, 7, 2);
dataTable.setValue(5, 8, 0);
dataTable.setValue(5, 9, 0);

dataTable.setValue(6, 0, 0);
dataTable.setValue(6, 1, 15);
dataTable.setValue(6, 2, 0);
dataTable.setValue(6, 3, 2);
dataTable.setValue(6, 4, 0);
dataTable.setValue(6, 5, 0);
dataTable.setValue(6, 6, 0);
dataTable.setValue(6, 7, 1);
dataTable.setValue(6, 8, 0);
dataTable.setValue(6, 9, 0);

dataTable.setValue(7, 0, 0);
dataTable.setValue(7, 1, 21);
dataTable.setValue(7, 2, 0);
dataTable.setValue(7, 3, 2);
dataTable.setValue(7, 4, 0);
dataTable.setValue(7, 5, 0);
dataTable.setValue(7, 6, 0);
dataTable.setValue(7, 7, 1);
dataTable.setValue(7, 8, 2);
dataTable.setValue(7, 9, 0);

dataTable.setValue(8, 0, 0);
dataTable.setValue(8, 1, 18);
dataTable.setValue(8, 2, 0);
dataTable.setValue(8, 3, 1);
dataTable.setValue(8, 4, 0);
dataTable.setValue(8, 5, 0);
dataTable.setValue(8, 6, 0);
dataTable.setValue(8, 7, 0);
dataTable.setValue(8, 8, 0);
dataTable.setValue(8, 9, 0);

dataTable.setValue(9, 0, 0);
dataTable.setValue(9, 1, 16);
dataTable.setValue(9, 2, 0);
dataTable.setValue(9, 3, 0);
dataTable.setValue(9, 4, 0);
dataTable.setValue(9, 5, 0);
dataTable.setValue(9, 6, 0);
dataTable.setValue(9, 7, 1);
dataTable.setValue(9, 8, 0);
dataTable.setValue(9, 9, 0);

dataTable.setValue(10, 0, 0);
dataTable.setValue(10, 1, 12);
dataTable.setValue(10, 2, 0);
dataTable.setValue(10, 3, 2);
dataTable.setValue(10, 4, 0);
dataTable.setValue(10, 5, 0);
dataTable.setValue(10, 6, 0);
dataTable.setValue(10, 7, 0);
dataTable.setValue(10, 8, 0);
dataTable.setValue(10, 9, 0);

dataTable.setValue(11, 0, 0);
dataTable.setValue(11, 1, 12);
dataTable.setValue(11, 2, 0);
dataTable.setValue(11, 3, 3);
dataTable.setValue(11, 4, 0);
dataTable.setValue(11, 5, 0);
dataTable.setValue(11, 6, 0);
dataTable.setValue(11, 7, 0);
dataTable.setValue(11, 8, 0);
dataTable.setValue(11, 9, 0);

dataTable.setValue(12, 0, 0);
dataTable.setValue(12, 1, 7);
dataTable.setValue(12, 2, 0);
dataTable.setValue(12, 3, 1);
dataTable.setValue(12, 4, 0);
dataTable.setValue(12, 5, 0);
dataTable.setValue(12, 6, 0);
dataTable.setValue(12, 7, 0);
dataTable.setValue(12, 8, 0);
dataTable.setValue(12, 9, 0);

dataTable.setValue(13, 0, 0);
dataTable.setValue(13, 1, 3);
dataTable.setValue(13, 2, 0);
dataTable.setValue(13, 3, 0);
dataTable.setValue(13, 4, 0);
dataTable.setValue(13, 5, 0);
dataTable.setValue(13, 6, 0);
dataTable.setValue(13, 7, 0);
dataTable.setValue(13, 8, 0);
dataTable.setValue(13, 9, 0);

draw(dataTable);
}
}

function draw(dataTable) {
var vis = new
google.visualization.ImageChart(document.getElementById('chart'));
var options = {
chxl: '0:|July|Jun|May|Apr|Mar|Feb|Jan|Dec|Nov|Oct|Sep|Aug|
July|Jun|2:|2011|||||||2010||||||',

chds: 'a',
chxp: '',
chma: '30,30,30,30',
chm: 'N,000000,-1,,20|N,000000,0,,12,,c|N,ffffff,1,,12,,c|
N,ffffff,2,,12,,c|N,ffffff,3,,12,,c|N,ffffff,4,,12,,c|N,ffffff,
5,,12,,c|N,ffffff,6,,12,,c|N,ffffff,7,,12,,c|N,ffffff,8,,12,,c|
N,ffffff,9,,12,,c',
chxr: '',
chxs: '',
chxtc: '',
chxt: 'x,y,x',
chbh: '40',
chs: '700x400',
cht: 'bvs',
chco:
'FDD017,436eee,FF9900,27408b,ff6a6a,ee6363,A2C180,8b3a3a,
3D7930,00ff00',
chd: 't:0,7,1,1,0,0,0,3,0,0|0,12,0,4,0,0,0,4,0,0|
0,37,0,5,0,0,0,4,1,0|0,13,1,2,0,0,1,2,0,0|0,21,0,0,0,1,0,0,0,0|
0,22,0,3,0,0,1,2,0,0|0,15,0,2,0,0,0,1,0,0|0,21,0,2,0,0,0,1,2,0|
0,18,0,1,0,0,0,0,0,0|0,16,0,0,0,0,0,1,0,0|0,12,0,2,0,0,0,0,0,0|
0,12,0,3,0,0,0,0,0,0|0,7,0,1,0,0,0,0,0,0|0,3,0,0,0,0,0,0,0,0',
chdlp: 'b',
chdl: 'ABDO|BRAI|LIVR|LUNG|MEDI|NECK|PANC|PELB|SPIN|OTHR',
chtt: 'Monthly New Courses Started',
chts:'436eee,20,l'
};
vis.draw(dataTable, options);
}

function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
draw(response.getDataTable());
}

google.load("visualization", "1", {packages:["imagechart"]});
google.setOnLoadCallback(onLoadCallback);

</script>

[duniyadnd]

Wrong group - https://groups.google.com/forum/#!forum/google-visualization-api