Uneven xaxis labels

18 views
Skip to first unread message

Vincent Roggero

unread,
Jan 29, 2018, 2:08:21 PM1/29/18
to Google Visualization API
I have a requirement for an audio frequency response line chart where the xaxis labels are not equal. Is this possible with Google Charts? Example image attached.

Labels: 20 50 100 200 500 1k 2k 5k 10k 20k

Data:
xAxis Frequency (Hz) yAxis Magnitude (dB)
1 -74.14225099
1.029302239 -73.72560506
1.059463143 -73.34862243
1.090507746 -73.01042552
1.122462034 -72.7095364
1.155352712 -72.44376664
1.189207077 -72.21012149
1.224053502 -72.00467598
1.259921074 -71.822448
1.296839595 -71.65724725
1.334839821 -71.50151238
1.3739537 -71.34614482
1.414213538 -71.18027224
1.455653191 -70.99106748
1.498307109 -70.76487581
1.542210817 -70.49730818
1.587401032 -70.18919433
1.633915424 -69.84189952
1.681792855 -69.45739253
1.731073141 -69.03834341
1.781797409 -68.58819034
1.834008098 -68.11127692
1.887748599 -67.6129625
1.943063855 -67.09975271
2 -66.57945172
2.058604479 -66.06134397
2.118926287 -65.5563501
2.181015491 -65.07725674
2.244924068 -64.63829055
2.310705423 -64.24995407
2.378414154 -63.92091289
2.448107004 -63.66079357
2.519842148 -63.48031017
2.59367919 -63.39137081
2.669679642 -63.40718729
2.7479074 -63.54242828
2.828427076 -63.81335295
2.911306381 -64.23797131
2.996614218 -64.83063725
3.084421635 -65.56123718
3.174802065 -66.37025373
3.267830849 -67.18611224
3.363585711 -67.92374128
3.462146282 -68.48289477
3.563594818 -68.74624221
3.668016195 -68.57728413
3.775497198 -67.86927235
3.88612771 -66.68175215
4 -65.13016202
4.117208958 -63.35522207
4.237852573 -61.52624105
4.362030983 -59.84484222
4.489848137 -58.52783181
4.621410847 -57.63198823
4.756828308 -57.1123887
4.896214008 -56.91071041
5.039684296 -56.95437491
5.187358379 -57.15559542
5.339359283 -57.44833439
5.4958148 -57.80649165
5.656854153 -58.20208073
5.822612762 -58.60149348
5.993228436 -58.96263636
6.168843269 -59.21824917
6.34960413 -59.28076235
6.535661697 -59.04795661
6.727171421 -58.43122038
6.924292564 -57.64821015
7.127189636 -57.15395943
7.336032391 -57.48909448
7.550994396 -58.97718452
7.772255421 -60.89193812
8 -62.12290764
8.234417915 -61.54691198
8.475705147 -59.54364259
8.724061966 -57.47702136
8.979696274 -56.79375664
9.242821693 -57.49814992
9.513656616 -58.64847677
9.792428017 -59.44976828
10.07936859 -60.4976559
10.37471676 -62.88721566
10.67871857 -66.02056007
10.9916296 -66.656976
11.31370831 -62.3251152
11.64522552 -56.21251039
11.98645687 -52.9425955
12.33768654 -52.3159643
12.69920826 -51.51796851
13.07132339 -49.91519929
13.45434284 -48.45863328
13.84858513 -47.62566596
14.25437927 -47.47984917
14.67206478 -47.49984218
15.10198879 -47.21064566
15.54451084 -47.42672951
16 -48.13286819
16.46883583 -47.66475167
16.95141029 -46.30108391
17.44812393 -46.67643543
17.95939255 -52.75838359
18.48564339 -56.25891258
19.02731323 -52.59977837
19.58485603 -52.45275533
20.15873718 -50.77434031
20.74943352 -48.32118052
21.35743713 -50.07178792
21.9832592 -53.74326238
22.62741661 -51.83291423
23.29045105 -44.9232244
23.97291374 -58.84645418
24.67537308 -51.01260186
25.39841652 -52.7850247
26.14264679 -49.42985044
26.90868568 -58.44401851
27.69717026 -48.19343077
28.50875854 -48.55603707
29.34412956 -48.98938164
30.20397758 -49.5915554
31.08902168 -44.61958884
32 -41.96073975
32.93767166 -46.94537188
33.90282059 -38.6476065
34.89624786 -40.93927829
35.9187851 -38.60295041
36.97128677 -36.18092999
38.05462646 -32.68629077
39.16971207 -32.04835429
40.31747437 -30.5372927
41.49886703 -29.52455551
42.71487427 -26.90102312
43.9665184 -25.75610188
45.25483322 -24.72932122
46.5809021 -22.83653277
47.94582748 -22.2931527
49.35074615 -21.50057566
50.79683304 -20.29324035
52.28529358 -19.91098978
53.81737137 -19.47735654
55.39434052 -19.14491878
57.01751709 -18.66658796
58.68825912 -18.38038915
60.40795517 -18.1120424
62.17804337 -18.28989847
64 -17.71111123
65.87534332 -17.38518744
67.80564117 -17.31931326
69.79249573 -17.41380312
71.83757019 -17.64015432
73.94257355 -17.57303405
76.10925293 -17.70765615
78.33942413 -18.30420481
80.63494873 -18.38987453
82.99773407 -18.64314535
85.42974854 -18.51996165
87.9330368 -18.23356078
90.50966644 -17.82038344
93.1618042 -17.50148788
95.89165497 -16.89358206
98.70149231 -16.631491
101.5936661 -16.58214223
104.5705872 -16.45352721
107.6347427 -17.02568682
110.788681 -16.85072751
114.0350342 -17.29511702
117.3765182 -17.14656005
120.8159103 -17.12970371
124.3560867 -16.8092235
128 -16.03376544
131.7506866 -15.75843486
135.6112823 -15.16466531
139.5849915 -15.52989702
143.6751404 -15.81521738
147.8851471 -16.11868378
152.2185059 -16.49247962
156.6788483 -15.68817862
161.2698975 -15.2766229
165.9954681 -14.52129464
170.8594971 -14.9247599
175.8660736 -15.21010669
181.0193329 -15.82958432
186.3236084 -16.44573357
191.7833099 -15.98380725
197.4029846 -15.22647289
203.1873322 -14.83446155
209.1411743 -15.31019595
215.2694855 -16.17978562
221.5773621 -16.46187988
228.0700684 -16.07107137
234.7530365 -16.56653546
241.6318207 -18.09664111
248.7121735 -15.29931218
256 -14.97978682
263.5013733 -14.35225497
271.2225647 -14.16250398
279.1699829 -14.38529594
287.3502808 -14.4748589
295.7702942 -14.36801663
304.4370117 -13.81965625
313.3576965 -14.63474011
322.5397949 -15.21047133
331.9909363 -14.29910545
341.7189941 -14.39650281
351.7321472 -15.43458853
362.0386658 -14.75063315
372.6472168 -14.21431433
383.5666199 -14.64850873
394.8059692 -15.09648775
406.3746643 -14.5366121
418.2823486 -15.48829467
430.5389709 -15.35879848
443.1547241 -15.28470185
456.1401367 -15.7147311
469.506073 -15.33331128
483.2636414 -15.60778151
497.4243469 -16.13136791
512 -15.99758157
527.0027466 -16.55658474
542.4451294 -15.40886152
558.3399658 -16.05868539
574.7005615 -15.13536897
591.5405884 -15.42153824
608.8740234 -14.27119271
626.7153931 -15.14027985
645.0795898 -15.08847822
663.9818726 -15.57044114
683.4379883 -15.0096726
703.4642944 -15.35363592
724.0773315 -15.47078111
745.2944336 -14.32352411
767.1332397 -14.66876267
789.6119385 -14.43518021
812.7493286 -14.3563152
836.5646973 -14.81849901
861.0779419 -14.93850566
886.3094482 -14.80210045
912.2802734 -14.93005849
939.012146 -15.6751605
966.5272827 -15.4839526
994.8486938 -15.50201789
1024 -15.17627208
1054.005493 -15.30635967
1084.890259 -15.20257583
1116.679932 -15.23998135
1149.401123 -15.30746958
1183.081177 -15.83279524
1217.748047 -15.275414
1253.430786 -14.93102819
1290.15918 -15.04524583
1327.963745 -15.18612517
1366.875977 -14.71520916
1406.928589 -14.51174954
1448.154663 -14.93419653
1490.588867 -14.98904794
1534.266479 -14.81323026
1579.223877 -14.94300349
1625.498657 -14.73062297
1673.129395 -14.8673895
1722.155884 -15.52225003
1772.618896 -14.77423178
1824.560547 -15.05688155
1878.024292 -14.90458616
1933.054565 -15.39090499
1989.697388 -15.20304222
2048 -15.04756836
2108.010986 -15.40641442
2169.780518 -15.70557679
2233.359863 -15.96711159
2298.802246 -16.42535202
2366.162354 -16.49209156
2435.496094 -16.08948796
2506.861572 -15.88324751
2580.318359 -15.79622068
2655.92749 -16.15433426
2733.751953 -15.70277713
2813.857178 -15.65788355
2896.309326 -15.49998154
2981.177734 -15.54056254
3068.532959 -15.46839026
3158.447754 -15.09887114
3250.997314 -14.66545715
3346.258789 -15.47295358
3444.311768 -16.56939419
3545.237793 -16.76922839
3649.121094 -16.30301336
3756.048584 -16.66371504
3866.109131 -16.57132758
3979.394775 -16.29913527
4096 -15.87763168
4216.021973 -16.2092101
4339.561035 -16.00310314
4466.719727 -15.62194907
4597.604492 -16.10806192
4732.324707 -16.39448152
4870.992188 -16.30571136
5013.723145 -16.95093755
5160.636719 -16.67896596
5311.85498 -16.9499217
5467.503906 -16.93109755
5627.714355 -16.52105238
5792.618652 -17.0413682
5962.355469 -17.44707227
6137.065918 -18.11049704
6316.895508 -18.68338953
6501.994629 -18.73896945
6692.517578 -19.16298049
6888.623535 -18.89708253
7090.475586 -18.96225037
7298.242188 -19.00784001
7512.097168 -19.4896566
7732.218262 -19.69838717
7958.789551 -19.58906878
8192 -19.26764741
8432.043945 -19.50868154
8679.12207 -20.33532841
8933.439453 -20.45729842
9195.208984 -20.37136343
9464.649414 -20.14683747
9741.984375 -20.02219695
10027.44629 -20.99721696
10321.27344 -21.67772273
10623.70996 -21.73251181
10935.00781 -22.27463689
11255.42871 -22.97679629
11585.2373 -23.85569379
11924.71094 -23.95825358
12274.13184 -24.25667515
12633.79102 -24.60818302
13003.98926 -24.54992313
13385.03516 -23.85461851
13777.24707 -23.41082131
14180.95117 -22.80662097
14596.48438 -22.20746259
15024.19434 -21.70623573
15464.43652 -22.01230525
15917.5791 -22.63672317
16384 -23.73829402
16864.08789 -24.4577049
17358.24414 -25.6838634
17866.87891 -26.60508171
18390.41797 -28.02838317
18929.29883 -29.57852798
19483.96875 -31.8295541
20054.89258 -33.84071379
20642.54688 -35.41686745
21247.41992 -36.71532826
21870.01563 -36.98398617
22510.85742 -37.87435286
23170.47461 -41.19339453

freq-chart.png

Daniel LaLiberte

unread,
Jan 29, 2018, 2:30:32 PM1/29/18
to Google Visualization API
That is a log scale on your x axis, which Google Charts does support.  Just specify in your options, hAxis.scaleType = 'log';

--
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 google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/eb684387-5391-4cff-a4e0-478d65cb46f6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages