In this part:
var chart = new
google.visualization.ScatterChart(document.getElementById('chart_div'));
chart.draw(view, options);
var chart = new
google.visualization.ScatterChart(document.getElementById('chart_div'));
chart.draw(data, options);
remove the second "var chart" and "chart.draw" lines (you just want one
chart and the "chart.draw(view, options);" line).
On Sunday, November 3, 2013 5:07:02 PM UTC-5, Santiago Fernandez wrote:
>
> The truth that you're a genius.
>
> The programming is not my thing. I am new and I realize this consisting
>
> Do not know how to thank you ... But I have some error in the Copy Paste.
>
> I Try this,
>
> <!-- Google Api -->
>
> <script type="text/javascript" src="https://www.google.com/jsapi
> "></script>
> <script type="text/javascript">
> google.load("visualization", "1", {packages:["corechart"]});
> google.setOnLoadCallback(drawChart);
> function drawChart() {
>
> var data = new google.visualization.DataTable();
> data.addColumn('number', 'coox');
> data.addColumn('number', 'cooy');
> data.addColumn('string', 'alianza');
> data.addColumn({type: 'string', role: 'tooltip', properties: {html:
> true}});
>
>
> <?php
> $listar_grafico = mysql_query("SELECT * FROM jugadores");
> while ($row = mysql_fetch_array($listar_grafico)) {
> ?>
> data.addRow([<?=$row['coox']?>, <?=$row['cooy']?>,
> <?=$row['alianza']?>,'<?=$row['jugador']?>']);
> <?
> }
> mysql_free_result($listar_grafico);
> ?>
>
> var alianzas = data.getDistinctValues(3); // get a list of all
> "Alianza"s
> var columns = [0];
> for (var i = 0; i < alianzas.length; i++) {
> columns.push({
> type: 'number',
> label: alianzas[i],
> calc: (function (x) {
> return function (dt, row) {
> return (dt.getValue(row, 3) == alianzas[x]) ?
> dt.getValue(row, 1) : null;
> };
> })(i)
> });
> columns.push({
> type: 'string',
> role: 'tooltip',
> properties: {isHtml: true},
> calc: (function (x) {
> return function (dt, row) {
> return (dt.getValue(row, 3) == alianzas[x]) ?
> dt.getValue(row, 2) : null;
> };
> })(i)
> });
> }
> var options = {
> title: 'Mapa de Alianza',
> hAxis: {title: 'Eje X', minValue: 0, maxValue: 1020},
> vAxis: {title: 'Eje Y', minValue: 0, maxValue: 1020},
> pointSize: 4
> };
> var view = new google.visualization.DataView(data);
> view.setColumns(columns);
>
> var chart = new
> google.visualization.ScatterChart(document.getElementById('chart_div'));
> chart.draw(view, options);
>
> var chart = new
> google.visualization.ScatterChart(document.getElementById('chart_div'));
> chart.draw(data, options);
> }
> google.load('visualization', '1', {packages:['corechart'], callback:
> drawChart});
> </script>
> <!-- Grafico -->
>
>
> And this!
>
> <!-- Google Api -->
>
> <script type="text/javascript" src="https://www.google.com/jsapi
> "></script>
> <script type="text/javascript">
> google.load("visualization", "1", {packages:["corechart"]});
> google.setOnLoadCallback(drawChart);
> function drawChart() {
>
> var data = new google.visualization.DataTable();
> data.addColumn('number', 'coox');
> data.addColumn('number', 'cooy');
> data.addColumn({type: 'string', role: 'tooltip', properties: {html:
> true}});
> data.addColumn('string', 'alianza');
>
>
> data.addRows([
> [346, 348, 'SirSantiago', 'Walter White'],
> [453, 453, 'Terminator34', 'Reino Plata'],
> [555, 555, 'GamerSabalero', 'Walter White'],
> [432, 334, 'AlexGamer', 'Walter White'],
> [232, 232, 'elFiaco8', 'Walter White']]);
>
> var alianzas = data.getDistinctValues(3); // get a list of all
> "Alianza"s
> var columns = [0];
> for (var i = 0; i < alianzas.length; i++) {
> columns.push({
> type: 'number',
> label: alianzas[i],
> calc: (function (x) {
> return function (dt, row) {
> return (dt.getValue(row, 3) == alianzas[x]) ?
> dt.getValue(row, 1) : null;
> };
> })(i)
> });
> columns.push({
> type: 'string',
> role: 'tooltip',
> properties: {isHtml: true},
> calc: (function (x) {
> return function (dt, row) {
> return (dt.getValue(row, 3) == alianzas[x]) ?
> dt.getValue(row, 2) : null;
> };
> })(i)
> });
> }
> var options = {
> title: 'Mapa de Alianza',
> hAxis: {title: 'Eje X', minValue: 0, maxValue: 1020},
> vAxis: {title: 'Eje Y', minValue: 0, maxValue: 1020},
> pointSize: 4
> };
> var view = new google.visualization.DataView(data);
> view.setColumns(columns);
>
> var chart = new
> google.visualization.ScatterChart(document.getElementById('chart_div'));
> chart.draw(view, options);
>
> var chart = new
> google.visualization.ScatterChart(document.getElementById('chart_div'));
> chart.draw(data, options);
> }
> google.load('visualization', '1', {packages:['corechart'], callback:
> drawChart});
> </script>
> <!-- Grafico —>
>
> Look...
>
> http://imm.io/1jMTR
>
> I'll have to pay you! Jajaj! or send an Argentine Wine!
>
> Thanks a lot!
>
> El 03/11/2013, a las 18:34, asgallant <[email protected]<javascript:>>
> escribió:
>
> I see. Yes, you can add "Alianza" to the DataTable in order to make the
> table at the top of your image. That format will not work for the chart,
> however, so you have to create a DataView that splits the data into
> different columns depending on the value of "Alianza".
>
> data.addColumn('number', 'COOX');
> data.addColumn('number', 'COOY');
> data.addColumn({type: 'string' role: 'tooltip', properties: {html: true}});
> data.addColumn('string', 'Alianza');
>
> <?php
> $Listar_grafico = mysql_query("SELECT * FROM players");
> while ($row = mysql_fetch_array($listar_graph)) {
> ?>
> data.addRow ([<?=$row['coox']?>, <?=$row['cooy']?>,
> '<?=$row['jugador']?>', '<?=$row['alianza']?>']);
> <?php
> mysql_free_result($listar_graph);
> ?>
>
> var alianzas = data.getDistinctValues(3); // get a list of all "Alianza"s
> var columns = [0];
> for (var i = 0; i < alianzas.length; i++) {
> columns.push({
> type: 'number',
> label: alianzas[i],
> calc: (function (x) {
> return function (dt, row) {
> return (dt.getValue(row, 3) == alianzas[x]) ?
> dt.getValue(row, 1) : null;
> };
> })(i)
> });
> columns.push({
> type: 'number',
> role: 'tooltip',
> properties: {isHtml: true},
> calc: (function (x) {
> return function (dt, row) {
> return (dt.getValue(row, 3) == alianzas[x]) ?
> dt.getValue(row, 2) : null;
> };
> })(i)
> });
> }
> var view = new google.visualization.DataView(data);
>
> Draw the chart using the DataView instead of the DataTable. You can set
> the colors in the chart's "colors" option. I made an example of this for
> you to follow: http://jsfiddle.net/asgallant/bMNYE/
>
> On Sunday, November 3, 2013 2:38:14 PM UTC-5, Santiago Fernandez wrote:
>>
>> En mi pais hay un dicho, que Una imagen dice mas que mil palabras.
>>
>> http://imm.io/1jMa7
>>
>> Esto es lo que pretendo hacer Assgalant.
>>
>> El 02/11/2013, a las 12:47, Fernandez Santiago <[email protected]>
>> escribió:
>>
>> Mi ingles es muy malo.
>>
>> Gracias por la atención, asgallant.
>>
>> Quiero crear un grafico de intersecciones. Lo he logrado. Ahora la idea
>> es dividir en 2. Con un color en base a un campo de la tabla y con otro
>> color en base a ese mismo campo.
>>
>> Ejemplo.
>>
>> var data = new google.visualization.DataTable();
>>>> data.addColumn('number', 'coox');
>>>> data.addColumn('number', 'cooy');
>>>> data.addColumn({type:'string', role:'tooltip', 'jugador':
>>>> {'html': true}}); // tooltip for first series
>>>
>>>
>> agregar,
>>
>> data.addColumn(’string’,’alianza’);
>>
>> Datos de la Tabla
>>
>> Si alianza = ‘alianza’ uso color Rojo y si no uso color Azul.
>>
>> Dividir en 2 grupos el grafico.
>>
>> Logras entender?
>>
>> Muchisimas gracias!!
>>
>>
>>
>> El 02/11/2013, a las 12:12, asgallant <[email protected]> escribió:
>>
>> I'm sorry, but I don't understand your questions. If you ask the
>> questions in your native language, I can try to have them translated.
>>
>> On Friday, November 1, 2013 11:29:00 PM UTC-4, Santiago Fernandez wrote:
>>>
>>> Dear,
>>>
>>> I'm not a developer. Then, a lot of effort to achieve graph a Scratter
>>> with the following code.
>>>
>>> This One...
>>>
>>> <script type="text/javascript">
>>>> google.load("visualization", "1", {packages:["corechart"]});
>>>> google.setOnLoadCallback(drawChart);
>>>> function drawChart() {
>>>> var data = new google.visualization.DataTable();
>>>> data.addColumn('number', 'coox');
>>>> data.addColumn('number', 'cooy');
>>>> data.addColumn({type:'string', role:'tooltip', 'jugador':
>>>> {'html': true}}); // tooltip for first series
>>>> <?php
>>>> $listar_grafico = mysql_query("SELECT * FROM jugadores");
>>>> while ($row = mysql_fetch_array($listar_grafico)) {
>>>> ?>
>>>> data.addRow([<?=$row['coox']?>, <?=$row['cooy']?>,
>>>> '<?=$row['jugador']?>']);
>>>> <?
>>>> }
>>>> mysql_free_result($listar_grafico);
>>>> ?>
>>>> var options = {
>>>> title: 'Mapa de Alianza',
>>>> hAxis: {title: 'Eje X', minValue: 0, maxValue: 1020},
>>>> vAxis: {title: 'Eje Y', minValue: 0, maxValue: 1020},
>>>> pointSize:4,
>>>> legend: 'none'
>>>> };
>>>> var chart = new
>>>> google.visualization.ScatterChart(document.getElementById('chart_div'));
>>>> chart.draw(data, options);
>>>> }
>>>> </script>
>>>
>>>
>>> I have some form of cross-checking with another?
>>>
>>> Or failing and add one more and with an IF color to the two groups of
>>> the same DataTable?
>>>
>>> Do you under stand me?
>>>
>>> Thanks!!
>>>
>>
>> --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "Google Visualization API" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/google-visualization-api/XXJkiugovDA/unsubscribe
>> .
>> To unsubscribe from this group and all its topics, send an email to
>> google-visualization-api+
>> <javascript:>[email protected]<javascript:>
>> .
>> To post to this group, send email to [email protected].
>> Visit this group at
>> http://groups.google.com/group/google-visualization-api.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Google Visualization API" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/google-visualization-api/XXJkiugovDA/unsubscribe
> .
> To unsubscribe from this group and all its topics, send an email to
> [email protected] <javascript:>.
> To post to this group, send email to
> [email protected]<javascript:>
> .
> Visit this group at
> http://groups.google.com/group/google-visualization-api.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
