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.
