Here's a DataView you can use to demo what it would look like:
var view = new google.visualization.DataView(data);
view.setColumns([{
type: 'date',
label: data.getColumnLabel(0),
calc: function (dt, row) {
var timestampArray = dt.getValue(row, 0).split('_');
var dateArray = timestampArray[1].split('-');
var timeArray = timestampArray[2].split('-');
var month = parseInt(dateArray[0]) - 1; // subtract 1 from month
because Date objects use 0-indexed months
var day = parseInt(dateArray[1]);
var hour = parseInt(timeArray[0]);
var minute = parseInt(timeArray[1]);
var second = parseInt(timeArray[2]);
return new Date(2013, month, day, hour, minute, second);
}
}, 1, 2, 3, 4]);
Draw the chart using the view instead of the DataTable:
new
google.visualization.LineChart(document.getElementById('NonProd_1')).draw(view,
{
width: 600,
height: 200,
title: 'ETE',
legend: {
position: 'none'
},
colors: ['red', 'blue', 'grey', 'green'],
vAxis: {
viewWindowMode: 'explict'
}
});
On Tuesday, August 27, 2013 1:42:01 PM UTC-4, Chris Stamoulis wrote:
>
> Thank you for the reply! I am sorry, I do not understand. Is it possible
> that you can provide an example? Thanks!
>
> On Tuesday, August 27, 2013 1:29:58 PM UTC-4, asgallant wrote:
>>
>> Perhaps the easiest thing to do would be to convert your timestamp
>> strings into Date objects, eg 'Run_8-26_22-21-54' would be new
>> Date(2013, 7, 26, 22, 21, 54).
>>
>> On Tuesday, August 27, 2013 12:42:03 PM UTC-4, Chris Stamoulis wrote:
>>>
>>> Hello,
>>>
>>>
>>> I have a line chart with a lot of data points that I need to fit into a
>>> rect 600px X 200px. I would like to have the x axis be readable. This might
>>> mean to show a point for each daterather than each time & date. I need the
>>> line points to show each time/date however.
>>>
>>> Please advise as I have been scratching my head on this one for quite
>>> some time :)
>>>
>>> Many many many thanks in advance!!
>>>
>>> CODE:
>>>
>>> function drawVisualization() { var data =
>>> google.visualization.arrayToDataTable([['Date/Time', 'Upper Limit',
>>> 'Lower Control', 'Baseline Average', 'Duration'], ['Run_7-31_15-43-47',
>>> 758.2, 699.3, 728.8, 750], ['Run_7-31_17-13-9', 758.2, 699.3, 728.8,
>>> 765], ['Run_7-31_18-29-52', 758.2, 699.3, 728.8, 726],['Run_7-31_19-43-39',
>>> 758.2, 699.3, 728.8, 738],['Run_7-31_22-11-4', 758.2, 699.3, 728.8,
>>> 719],['Run_8-1_5-9-15', 758.2, 699.3, 728.8, 725],['Run_8-1_6-30-28',
>>> 758.2, 699.3, 728.8, 718],['Run_8-1_7-45-45', 758.2, 699.3, 728.8,
>>> 717],['Run_8-1_9-12-37', 758.2, 699.3, 728.8, 723],['Run_8-1_10-31-28',
>>> 758.2, 699.3, 728.8, 735],['Run_8-1_11-50-42', 758.2, 699.3, 728.8,
>>> 755],['Run_8-1_18-31-10', 758.2, 699.3, 728.8, 726],['Run_8-1_19-48-45',
>>> 758.2, 699.3, 728.8, 732],['Run_8-1_21-6-11', 758.2, 699.3, 728.8,
>>> 755],['Run_8-1_22-27-4', 758.2, 699.3, 728.8, 750],['Run_8-2_6-27-14',
>>> 758.2, 699.3, 728.8, 715],['Run_8-2_8-35-14', 758.2, 699.3, 728.8,
>>> 749],['Run_8-2_10-48-53', 758.2, 699.3, 728.8, 766],['Run_8-2_13-14-27',
>>> 758.2, 699.3, 728.8, 741],['Run_8-2_16-33-47', 758.2, 699.3, 728.8,
>>> 717],['Run_8-2_19-48-46', 758.2, 699.3, 728.8, 724],['Run_8-3_6-23-34',
>>> 758.2, 699.3, 728.8, 714],['Run_8-3_7-48-7', 758.2, 699.3, 728.8,
>>> 721],['Run_8-3_9-0-32', 758.2, 699.3, 728.8, 717],['Run_8-3_10-19-48',
>>> 758.2, 699.3, 728.8, 712],['Run_8-3_11-58-57', 758.2, 699.3, 728.8,
>>> 715],['Run_8-3_13-34-43', 758.2, 699.3, 728.8, 712],['Run_8-3_15-17-12',
>>> 758.2, 699.3, 728.8, 715],['Run_8-3_17-3-23', 758.2, 699.3, 728.8,
>>> 718],['Run_8-3_18-47-18', 758.2, 699.3, 728.8, 722],['Run_8-3_20-20-44',
>>> 758.2, 699.3, 728.8, 711],['Run_8-3_21-57-45', 758.2, 699.3, 728.8,
>>> 719],['Run_8-5_5-24-30', 758.2, 699.3, 728.8, 722],['Run_8-5_6-47-32',
>>> 758.2, 699.3, 728.8, 727],['Run_8-5_8-7-59', 758.2, 699.3, 728.8,
>>> 730],['Run_8-5_9-48-20', 758.2, 699.3, 728.8, 731],['Run_8-5_11-3-30',
>>> 758.2, 699.3, 728.8, 726],['Run_8-5_12-15-11', 758.2, 699.3, 728.8,
>>> 723],['Run_8-5_18-10-50', 758.2, 699.3, 728.8, 720],['Run_8-5_19-32-22',
>>> 758.2, 699.3, 728.8, 716],['Run_8-5_20-51-15', 758.2, 699.3, 728.8,
>>> 728],['Run_8-5_22-16-43', 758.2, 699.3, 728.8, 718],['Run_8-6_5-18-3',
>>> 758.2, 699.3, 728.8, 729],['Run_8-6_6-48-25', 758.2, 699.3, 728.8,
>>> 751],['Run_8-6_8-4-46', 758.2, 699.3, 728.8, 722],['Run_8-6_9-24-25',
>>> 758.2, 699.3, 728.8, 739],['Run_8-6_10-35-17', 758.2, 699.3, 728.8,
>>> 724],['Run_8-6_11-41-19', 758.2, 699.3, 728.8, 730],['Run_8-6_12-50-57',
>>> 758.2, 699.3, 728.8, 723],['Run_8-6_14-7-7', 758.2, 699.3, 728.8,
>>> 733],['Run_8-6_15-22-26', 758.2, 699.3, 728.8, 761],['Run_8-6_16-42-10',
>>> 758.2, 699.3, 728.8, 718],['Run_8-6_18-5-34', 758.2, 699.3, 728.8,
>>> 727],['Run_8-6_19-31-16', 758.2, 699.3, 728.8, 726],['Run_8-6_21-5-58',
>>> 758.2, 699.3, 728.8, 741],['Run_8-7_4-20-13', 758.2, 699.3, 728.8,
>>> 723],['Run_8-7_5-22-28', 758.2, 699.3, 728.8, 725],['Run_8-7_6-41-51',
>>> 758.2, 699.3, 728.8, 739],['Run_8-7_9-30-53', 758.2, 699.3, 728.8,
>>> 720],['Run_8-7_11-8-37', 758.2, 699.3, 728.8, 733],['Run_8-7_12-19-27',
>>> 758.2, 699.3, 728.8, 736],['Run_8-7_13-45-13', 758.2, 699.3, 728.8,
>>> 740],['Run_8-7_15-16-39', 758.2, 699.3, 728.8, 755],['Run_8-7_16-39-8',
>>> 758.2, 699.3, 728.8, 770],['Run_8-7_17-54-50', 758.2, 699.3, 728.8,
>>> 761],['Run_8-7_19-2-32', 758.2, 699.3, 728.8, 720],['Run_8-7_20-35-51',
>>> 758.2, 699.3, 728.8, 720],['Run_8-7_22-25-23', 758.2, 699.3, 728.8,
>>> 721],['Run_8-8_5-51-42', 758.2, 699.3, 728.8, 729],['Run_8-8_7-13-49',
>>> 758.2, 699.3, 728.8, 733],['Run_8-8_8-38-45', 758.2, 699.3, 728.8,
>>> 737],['Run_8-8_10-20-28', 758.2, 699.3, 728.8, 723],['Run_8-8_11-36-33',
>>> 758.2, 699.3, 728.8, 732],['Run_8-8_16-6-31', 758.2, 699.3, 728.8,
>>> 731],['Run_8-8_17-22-37', 758.2, 699.3, 728.8, 710],['Run_8-8_18-45-25',
>>> 758.2, 699.3, 728.8, 727],['Run_8-8_20-57-5', 758.2, 699.3, 728.8,
>>> 724],['Run_8-8_21-59-19', 758.2, 699.3, 728.8, 723],['Run_8-9_4-52-6',
>>> 758.2, 699.3, 728.8, 729],['Run_8-9_6-21-43', 758.2, 699.3, 728.8,
>>> 711],['Run_8-9_7-26-57', 758.2, 699.3, 728.8, 713],['Run_8-9_8-35-6',
>>> 758.2, 699.3, 728.8, 761],['Run_8-9_9-49-34', 758.2, 699.3, 728.8,
>>> 754],['Run_8-10_4-39-59', 758.2, 699.3, 728.8, 730],['Run_8-10_5-55-53',
>>> 758.2, 699.3, 728.8, 728],['Run_8-10_7-6-40', 758.2, 699.3, 728.8,
>>> 723],['Run_8-10_8-17-40', 758.2, 699.3, 728.8, 723],['Run_8-10_10-22-33',
>>> 758.2, 699.3, 728.8, 723],['Run_8-10_11-49-52', 758.2, 699.3, 728.8,
>>> 725],['Run_8-10_13-42-50', 758.2, 699.3, 728.8, 713],['Run_8-10_15-35-14',
>>> 758.2, 699.3, 728.8, 719],['Run_8-10_17-35-18', 758.2, 699.3, 728.8,
>>> 718],['Run_8-10_19-33-3', 758.2, 699.3, 728.8, 718],['Run_8-10_21-23-32',
>>> 758.2, 699.3, 728.8, 716],['Run_8-12_4-38-33', 758.2, 699.3, 728.8,
>>> 723],['Run_8-12_6-2-21', 758.2, 699.3, 728.8, 717],['Run_8-12_7-21-58',
>>> 758.2, 699.3, 728.8, 730],['Run_8-12_8-42-32', 758.2, 699.3, 728.8,
>>> 738],['Run_8-12_10-7-31', 758.2, 699.3, 728.8, 734],['Run_8-12_11-29-20',
>>> 758.2, 699.3, 728.8, 725],['Run_8-12_12-44-11', 758.2, 699.3, 728.8,
>>> 708],['Run_8-12_13-55-42', 758.2, 699.3, 728.8, 725],['Run_8-12_15-11-27',
>>> 758.2, 699.3, 728.8, 730],['Run_8-12_16-26-18', 758.2, 699.3, 728.8,
>>> 716],['Run_8-12_17-56-44', 758.2, 699.3, 728.8, 750],['Run_8-12_19-7-7',
>>> 758.2, 699.3, 728.8, 717],['Run_8-12_20-15-15', 758.2, 699.3, 728.8,
>>> 717],['Run_8-12_21-22-51', 758.2, 699.3, 728.8, 720],['Run_8-12_22-30-16',
>>> 758.2, 699.3, 728.8, 714],['Run_8-13_5-12-22', 758.2, 699.3, 728.8,
>>> 735],['Run_8-13_6-19-8', 758.2, 699.3, 728.8, 726],['Run_8-13_7-16-44',
>>> 758.2, 699.3, 728.8, 722],['Run_8-13_8-28-35', 758.2, 699.3, 728.8,
>>> 744],['Run_8-13_9-57-19', 758.2, 699.3, 728.8, 788],['Run_8-13_11-11-43',
>>> 758.2, 699.3, 728.8, 731],['Run_8-13_12-35-29', 758.2, 699.3, 728.8,
>>> 723],['Run_8-13_13-45-30', 758.2, 699.3, 728.8, 721],['Run_8-13_14-49-37',
>>> 758.2, 699.3, 728.8, 726],['Run_8-13_16-18-38', 758.2, 699.3, 728.8,
>>> 723],['Run_8-13_17-32-28', 758.2, 699.3, 728.8, 731],['Run_8-13_18-44-41',
>>> 758.2, 699.3, 728.8, 719],['Run_8-13_19-53-32', 758.2, 699.3, 728.8,
>>> 724],['Run_8-13_21-2-36', 758.2, 699.3, 728.8, 719],['Run_8-13_22-31-23',
>>> 758.2, 699.3, 728.8, 713],['Run_8-14_5-32-44', 758.2, 699.3, 728.8,
>>> 729],['Run_8-14_6-39-55', 758.2, 699.3, 728.8, 740],['Run_8-14_7-48-43',
>>> 758.2, 699.3, 728.8, 725],['Run_8-14_8-56-55', 758.2, 699.3, 728.8,
>>> 730],['Run_8-14_10-6-28', 758.2, 699.3, 728.8, 738],['Run_8-14_11-29-31',
>>> 758.2, 699.3, 728.8, 724],['Run_8-14_12-36-54', 758.2, 699.3, 728.8,
>>> 731],['Run_8-14_14-46-8', 758.2, 699.3, 728.8, 725],['Run_8-14_16-55-35',
>>> 758.2, 699.3, 728.8, 731],['Run_8-14_19-15-54', 758.2, 699.3, 728.8,
>>> 726],['Run_8-15_11-57-10', 758.2, 699.3, 728.8, 741],['Run_8-15_13-10-29',
>>> 758.2, 699.3, 728.8, 775],['Run_8-15_17-40-50', 758.2, 699.3, 728.8,
>>> 834],['Run_8-15_19-9-39', 758.2, 699.3, 728.8, 727],['Run_8-15_20-16-32',
>>> 758.2, 699.3, 728.8, 728],['Run_8-15_21-25-40', 758.2, 699.3, 728.8,
>>> 745],['Run_8-15_22-33-6', 758.2, 699.3, 728.8, 741],['Run_8-16_5-16-45',
>>> 758.2, 699.3, 728.8, 731],['Run_8-16_7-49-6', 758.2, 699.3, 728.8,
>>> 740],['Run_8-16_9-6-54', 758.2, 699.3, 728.8, 739],['Run_8-16_10-21-54',
>>> 758.2, 699.3, 728.8, 737],['Run_8-16_11-40-16', 758.2, 699.3, 728.8,
>>> 741],['Run_8-16_12-57-6', 758.2, 699.3, 728.8, 744],['Run_8-16_14-16-16',
>>> 758.2, 699.3, 728.8, 730],['Run_8-16_15-34-9', 758.2, 699.3, 728.8,
>>> 726],['Run_8-16_16-49-23', 758.2, 699.3, 728.8, 738],['Run_8-16_18-10-31',
>>> 758.2, 699.3, 728.8, 754],['Run_8-16_19-38-40', 758.2, 699.3, 728.8,
>>> 727],['Run_8-16_21-32-47', 758.2, 699.3, 728.8, 729],['Run_8-17_8-53-42',
>>> 758.2, 699.3, 728.8, 735],['Run_8-17_9-53-9', 758.2, 699.3, 728.8,
>>> 727],['Run_8-17_11-1-16', 758.2, 699.3, 728.8, 722],['Run_8-17_12-6-52',
>>> 758.2, 699.3, 728.8, 720],['Run_8-17_13-20-7', 758.2, 699.3, 728.8,
>>> 725],['Run_8-17_14-33-4', 758.2, 699.3, 728.8, 732],['Run_8-17_15-45-13',
>>> 758.2, 699.3, 728.8, 728],['Run_8-17_16-57-29', 758.2, 699.3, 728.8,
>>> 731],['Run_8-17_18-7-52', 758.2, 699.3, 728.8, 720],['Run_8-17_19-19-46',
>>> 758.2, 699.3, 728.8, 727],['Run_8-17_20-29-37', 758.2, 699.3, 728.8,
>>> 737],['Run_8-17_21-43-36', 758.2, 699.3, 728.8, 727],['Run_8-19_4-47-58',
>>> 758.2, 699.3, 728.8, 717],['Run_8-19_6-4-9', 758.2, 699.3, 728.8,
>>> 733],['Run_8-19_7-16-10', 758.2, 699.3, 728.8, 727],['Run_8-19_8-24-55',
>>> 758.2, 699.3, 728.8, 749],['Run_8-19_10-40-6', 758.2, 699.3, 728.8,
>>> 735],['Run_8-19_11-55-37', 758.2, 699.3, 728.8, 741],['Run_8-19_13-15-19',
>>> 758.2, 699.3, 728.8, 719],['Run_8-19_14-28-53', 758.2, 699.3, 728.8,
>>> 744],['Run_8-19_15-59-56', 758.2, 699.3, 728.8, 785],['Run_8-19_17-13-16',
>>> 758.2, 699.3, 728.8, 737],['Run_8-20_4-46-53', 758.2, 699.3, 728.8,
>>> 725],['Run_8-20_6-12-14', 758.2, 699.3, 728.8, 717],['Run_8-20_7-31-23',
>>> 758.2, 699.3, 728.8, 733],['Run_8-20_8-49-53', 758.2, 699.3, 728.8,
>>> 738],['Run_8-20_11-11-21', 758.2, 699.3, 728.8, 737],['Run_8-20_12-17-46',
>>> 758.2, 699.3, 728.8, 731],['Run_8-20_13-28-24', 758.2, 699.3, 728.8,
>>> 729],['Run_8-20_14-37-23', 758.2, 699.3, 728.8, 742],['Run_8-20_15-57-37',
>>> 758.2, 699.3, 728.8, 744],['Run_8-20_17-9-26', 758.2, 699.3, 728.8,
>>> 731],['Run_8-20_18-25-21', 758.2, 699.3, 728.8, 729],['Run_8-20_19-45-48',
>>> 758.2, 699.3, 728.8, 728],['Run_8-20_21-16-26', 758.2, 699.3, 728.8,
>>> 726],['Run_8-21_4-20-33', 758.2, 699.3, 728.8, 722],['Run_8-21_5-39-34',
>>> 758.2, 699.3, 728.8, 741],['Run_8-21_6-54-18', 758.2, 699.3, 728.8,
>>> 722],['Run_8-21_8-7-50', 758.2, 699.3, 728.8, 732],['Run_8-21_9-27-39',
>>> 758.2, 699.3, 728.8, 739],['Run_8-21_10-53-11', 758.2, 699.3, 728.8,
>>> 725],['Run_8-21_12-3-29', 758.2, 699.3, 728.8, 732],['Run_8-21_13-13-24',
>>> 758.2, 699.3, 728.8, 713],['Run_8-21_15-42-1', 758.2, 699.3, 728.8,
>>> 721],['Run_8-21_17-1-38', 758.2, 699.3, 728.8, 720],['Run_8-21_18-13-40',
>>> 758.2, 699.3, 728.8, 727],['Run_8-21_19-18-4', 758.2, 699.3, 728.8,
>>> 719],['Run_8-21_20-27-12', 758.2, 699.3, 728.8, 734],['Run_8-21_21-37-36',
>>> 758.2, 699.3, 728.8, 721],['Run_8-22_4-42-30', 758.2, 699.3, 728.8,
>>> 723],['Run_8-22_5-58-13', 758.2, 699.3, 728.8, 725],['Run_8-22_7-17-27',
>>> 758.2, 699.3, 728.8, 733],['Run_8-22_8-29-50', 758.2, 699.3, 728.8,
>>> 739],['Run_8-22_9-55-20', 758.2, 699.3, 728.8, 735],['Run_8-22_11-19-26',
>>> 758.2, 699.3, 728.8, 742],['Run_8-22_12-51-25', 758.2, 699.3, 728.8,
>>> 721],['Run_8-22_17-5-54', 758.2, 699.3, 728.8, 846],['Run_8-22_18-28-27',
>>> 758.2, 699.3, 728.8, 742],['Run_8-22_20-21-11', 758.2, 699.3, 728.8,
>>> 722],['Run_8-22_22-13-25', 758.2, 699.3, 728.8, 729],['Run_8-23_5-32-52',
>>> 758.2, 699.3, 728.8, 722],['Run_8-23_6-49-57', 758.2, 699.3, 728.8,
>>> 726],['Run_8-23_8-3-53', 758.2, 699.3, 728.8, 717],['Run_8-23_9-27-25',
>>> 758.2, 699.3, 728.8, 730],['Run_8-23_10-50-56', 758.2, 699.3, 728.8,
>>> 748],['Run_8-23_12-19-47', 758.2, 699.3, 728.8, 716],['Run_8-23_13-57-55',
>>> 758.2, 699.3, 728.8, 743],['Run_8-23_15-29-50', 758.2, 699.3, 728.8,
>>> 733],['Run_8-23_16-46-19', 758.2, 699.3, 728.8, 721],['Run_8-23_18-4-8',
>>> 758.2, 699.3, 728.8, 722],['Run_8-23_19-24-30', 758.2, 699.3, 728.8,
>>> 735],['Run_8-23_20-51-16', 758.2, 699.3, 728.8, 724],['Run_8-24_4-46-55',
>>> 758.2, 699.3, 728.8, 721],['Run_8-24_6-8-12', 758.2, 699.3, 728.8,
>>> 722],['Run_8-24_7-31-35', 758.2, 699.3, 728.8, 718],['Run_8-24_9-19-56',
>>> 758.2, 699.3, 728.8, 728],['Run_8-24_10-44-5', 758.2, 699.3, 728.8,
>>> 717],['Run_8-24_12-5-30', 758.2, 699.3, 728.8, 719],['Run_8-24_13-39-33',
>>> 758.2, 699.3, 728.8, 725],['Run_8-24_14-59-6', 758.2, 699.3, 728.8,
>>> 711],['Run_8-24_16-23-29', 758.2, 699.3, 728.8, 723],['Run_8-24_17-48-51',
>>> 758.2, 699.3, 728.8, 720],['Run_8-24_19-22-24', 758.2, 699.3, 728.8,
>>> 720],['Run_8-24_20-56-39', 758.2, 699.3, 728.8, 727],['Run_8-24_22-22-26',
>>> 758.2, 699.3, 728.8, 725],['Run_8-26_5-24-9', 758.2, 699.3, 728.8,
>>> 721],['Run_8-26_6-42-39', 758.2, 699.3, 728.8, 717],['Run_8-26_7-50-38',
>>> 758.2, 699.3, 728.8, 723],['Run_8-26_9-9-43', 758.2, 699.3, 728.8,
>>> 718],['Run_8-26_10-34-38', 758.2, 699.3, 728.8, 719],['Run_8-26_11-50-2',
>>> 758.2, 699.3, 728.8, 720],['Run_8-26_13-5-19', 758.2, 699.3, 728.8,
>>> 718],['Run_8-26_14-23-44', 758.2, 699.3, 728.8, 724],['Run_8-26_14-33-16',
>>> 758.2, 699.3, 728.8, 713],['Run_8-26_15-41-46', 758.2, 699.3, 728.8,
>>> 727],['Run_8-26_17-0-53', 758.2, 699.3, 728.8, 717],['Run_8-26_18-24-51',
>>> 758.2, 699.3, 728.8, 735],['Run_8-26_19-44-46', 758.2, 699.3, 728.8,
>>> 719],['Run_8-26_21-7-38', 758.2, 699.3, 728.8, 780],['Run_8-26_22-21-54',
>>> 758.2, 699.3, 728.8, 742]]); new
>>> google.visualization.LineChart(document.getElementById('NonProd_1')).
>>> draw(data,
>>> { width: 600, height: 200, title: 'ETE', legend: {position: 'none'},
>>> colors:
>>> ['red', 'blue', 'grey', 'green'], vAxis: { viewWindowMode: 'explict', } });
>>> } google.load('visualization', '1', {packages:['corechart']});
>>> google.setOnLoadCallback(drawVisualization);
>>>
>>
--
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.
