Can I make this graph?

A

alhajoth

New Member
Joined
Jul 22, 2009
Messages
48
Hi,


I'm hoping to make this graph:

graphqg.png

from this dataset:

[TABLE="width: 958"]
<tbody>[TR]
[TD="width: 80"][/TD]
[TD="width: 80"][/TD]
[TD="class: xl68, width: 798, colspan: 24"]Time of day[/TD]
[/TR]
[TR]
[TD]Kanal[/TD]
[TD]Date[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD="class: xl68"]TV[/TD]
[TD="class: xl67"]22.07.2012[/TD]
[TD="align: right"]0,8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0,4[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0,7[/TD]
[TD="align: right"]1,1[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]0,4[/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0,9[/TD]
[TD="align: right"]0,5[/TD]
[/TR]
[TR]
[TD="class: xl67"]23.07.2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]24.07.2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]25.07.2012[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0,1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,4[/TD]
[TD="align: right"]0,8[/TD]
[TD="align: right"]1,3[/TD]
[TD="align: right"]2,7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5,9[/TD]
[TD="align: right"]2,3[/TD]
[TD="align: right"]3,4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4,7[/TD]
[TD="align: right"]6,1[/TD]
[TD="align: right"]1,7[/TD]
[/TR]
[TR]
[TD="class: xl67"]26.07.2012[/TD]
[TD="align: right"]0,3[/TD]
[TD][/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]0,1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,9[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]0,7[/TD]
[TD="align: right"]0,6[/TD]
[TD="align: right"]0,6[/TD]
[TD="align: right"]1,5[/TD]
[TD="align: right"]2,2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1,8[/TD]
[TD="align: right"]9,5[/TD]
[TD="align: right"]0,4[/TD]
[/TR]
[TR]
[TD="class: xl67"]27.07.2012[/TD]
[TD="align: right"]0,7[/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,4[/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0,5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0,8[/TD]
[TD][/TD]
[TD="align: right"]2,3[/TD]
[TD="align: right"]5,6[/TD]
[TD="align: right"]0,8[/TD]
[TD="align: right"]3,7[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]1,8[/TD]
[/TR]
[TR]
[TD="class: xl67"]28.07.2012[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]0,6[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]1,4[/TD]
[TD="align: right"]1,5[/TD]
[TD="align: right"]2,5[/TD]
[TD="align: right"]2,9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,8[/TD]
[TD="align: right"]7,5[/TD]
[TD="align: right"]5,9[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]1,6[/TD]
[/TR]
[TR]
[TD="class: xl67"]29.07.2012[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,9[/TD]
[TD="align: right"]1,3[/TD]
[TD="align: right"]1,2[/TD]
[TD="align: right"]1,3[/TD]
[TD="align: right"]0,8[/TD]
[TD="align: right"]1,5[/TD]
[TD="align: right"]0,9[/TD]
[TD="align: right"]3,5[/TD]
[TD="align: right"]1,5[/TD]
[TD="align: right"]5,6[/TD]
[TD="align: right"]3,9[/TD]
[TD="align: right"]6,7[/TD]
[TD="align: right"]7,1[/TD]
[TD="align: right"]4,4[/TD]
[TD="align: right"]1,5[/TD]
[TD="align: right"]0,4[/TD]
[/TR]
[TR]
[TD="class: xl67"]30.07.2012[/TD]
[TD="align: right"]1,1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,4[/TD]
[TD="align: right"]0,9[/TD]
[TD][/TD]
[TD="align: right"]0,4[/TD]
[TD="align: right"]3,5[/TD]
[TD="align: right"]1,8[/TD]
[TD="align: right"]3,8[/TD]
[TD="align: right"]2,4[/TD]
[TD="align: right"]8,3[/TD]
[TD="align: right"]13,2[/TD]
[TD="align: right"]5,6[/TD]
[TD="align: right"]2,2[/TD]
[TD="align: right"]0,7[/TD]
[/TR]
[TR]
[TD="class: xl67"]31.07.2012[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,7[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,5[/TD]
[TD="align: right"]0,9[/TD]
[TD="align: right"]3,5[/TD]
[TD="align: right"]2,1[/TD]
[TD="align: right"]4,1[/TD]
[TD="align: right"]0,9[/TD]
[TD="align: right"]5,7[/TD]
[TD="align: right"]19,4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]13,6[/TD]
[TD="align: right"]2,4[/TD]
[/TR]
[TR]
[TD="class: xl67"]01.08.2012[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]2,5[/TD]
[TD="align: right"]6,9[/TD]
[TD="align: right"]4,3[/TD]
[TD="align: right"]6,3[/TD]
[TD="align: right"]1,4[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl67"]02.08.2012[/TD]
[TD="align: right"]0,8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0,6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1,8[/TD]
[TD="align: right"]1,8[/TD]
[TD="align: right"]4,8[/TD]
[TD="align: right"]5,1[/TD]
[TD="align: right"]12,6[/TD]
[TD="align: right"]3,6[/TD]
[TD][/TD]
[TD="align: right"]3,9[/TD]
[TD="align: right"]0,2[/TD]
[/TR]
[TR]
[TD="class: xl67"]03.08.2012[/TD]
[TD="align: right"]2,8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]1,6[/TD]
[TD="align: right"]0,3[/TD]
[TD="align: right"]1,1[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]3,6[/TD]
[TD="align: right"]4,6[/TD]
[TD="align: right"]6,2[/TD]
[TD="align: right"]3,3[/TD]
[TD="align: right"]3,9[/TD]
[TD="align: right"]4,9[/TD]
[TD="align: right"]1,4[/TD]
[/TR]
[TR]
[TD="class: xl67"]04.08.2012[/TD]
[TD="align: right"]0,2[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]0,1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,7[/TD]
[TD="align: right"]1,8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0,6[/TD]
[TD="align: right"]1,2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68"]Trafikk[/TD]
[TD="class: xl67"]22.07.2012[/TD]
[TD="align: right"]633[/TD]
[TD="align: right"]327[/TD]
[TD="align: right"]210[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]272[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]1474[/TD]
[TD="align: right"]2279[/TD]
[TD="align: right"]2733[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]2534[/TD]
[TD="align: right"]2237[/TD]
[TD="align: right"]2025[/TD]
[TD="align: right"]2105[/TD]
[TD="align: right"]2036[/TD]
[TD="align: right"]2227[/TD]
[TD="align: right"]2394[/TD]
[TD="align: right"]2314[/TD]
[TD="align: right"]2479[/TD]
[TD="align: right"]2639[/TD]
[TD="align: right"]2530[/TD]
[TD="align: right"]2065[/TD]
[TD="align: right"]1241[/TD]
[/TR]
[TR]
[TD="class: xl67"]23.07.2012[/TD]
[TD][/TD]
[TD="align: right"]429[/TD]
[TD="align: right"]197[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]257[/TD]
[TD="align: right"]710[/TD]
[TD="align: right"]1474[/TD]
[TD="align: right"]2336[/TD]
[TD="align: right"]2670[/TD]
[TD="align: right"]2530[/TD]
[TD="align: right"]2280[/TD]
[TD="align: right"]2286[/TD]
[TD="align: right"]2086[/TD]
[TD="align: right"]1888[/TD]
[TD="align: right"]1832[/TD]
[TD="align: right"]1890[/TD]
[TD="align: right"]1843[/TD]
[TD="align: right"]1814[/TD]
[TD="align: right"]2045[/TD]
[TD="align: right"]2114[/TD]
[TD="align: right"]2119[/TD]
[TD="align: right"]1502[/TD]
[/TR]
[TR]
[TD="class: xl67"]24.07.2012[/TD]
[TD="align: right"]876[/TD]
[TD="align: right"]418[/TD]
[TD="align: right"]207[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]219[/TD]
[TD="align: right"]664[/TD]
[TD="align: right"]1364[/TD]
[TD="align: right"]1593[/TD]
[TD="align: right"]1969[/TD]
[TD="align: right"]1603[/TD]
[TD="align: right"]1480[/TD]
[TD="align: right"]1362[/TD]
[TD="align: right"]1384[/TD]
[TD="align: right"]1287[/TD]
[TD="align: right"]1177[/TD]
[TD="align: right"]1278[/TD]
[TD="align: right"]1226[/TD]
[TD="align: right"]1160[/TD]
[TD="align: right"]1430[/TD]
[TD="align: right"]1556[/TD]
[TD="align: right"]1460[/TD]
[TD="align: right"]1292[/TD]
[/TR]
[TR]
[TD="class: xl67"]25.07.2012[/TD]
[TD="align: right"]769[/TD]
[TD="align: right"]302[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]153[/TD]
[TD="align: right"]403[/TD]
[TD="align: right"]801[/TD]
[TD="align: right"]1217[/TD]
[TD="align: right"]1448[/TD]
[TD="align: right"]1453[/TD]
[TD="align: right"]1326[/TD]
[TD="align: right"]1258[/TD]
[TD="align: right"]1291[/TD]
[TD="align: right"]1175[/TD]
[TD="align: right"]1145[/TD]
[TD="align: right"]1283[/TD]
[TD="align: right"]1229[/TD]
[TD="align: right"]1284[/TD]
[TD="align: right"]1351[/TD]
[TD="align: right"]1578[/TD]
[TD="align: right"]1493[/TD]
[TD="align: right"]1248[/TD]
[/TR]
[TR]
[TD="class: xl67"]26.07.2012[/TD]
[TD="align: right"]820[/TD]
[TD="align: right"]371[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]204[/TD]
[TD="align: right"]443[/TD]
[TD="align: right"]856[/TD]
[TD="align: right"]1234[/TD]
[TD="align: right"]1429[/TD]
[TD="align: right"]1257[/TD]
[TD="align: right"]1208[/TD]
[TD="align: right"]1201[/TD]
[TD="align: right"]1145[/TD]
[TD="align: right"]1043[/TD]
[TD="align: right"]1200[/TD]
[TD="align: right"]1210[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1563[/TD]
[TD="align: right"]1657[/TD]
[TD="align: right"]2406[/TD]
[TD="align: right"]2558[/TD]
[TD="align: right"]2091[/TD]
[/TR]
[TR]
[TD="class: xl67"]27.07.2012[/TD]
[TD="align: right"]1322[/TD]
[TD="align: right"]538[/TD]
[TD="align: right"]253[/TD]
[TD="align: right"]146[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]320[/TD]
[TD="align: right"]678[/TD]
[TD="align: right"]1305[/TD]
[TD="align: right"]1811[/TD]
[TD="align: right"]1902[/TD]
[TD="align: right"]1855[/TD]
[TD="align: right"]1555[/TD]
[TD="align: right"]1675[/TD]
[TD="align: right"]1617[/TD]
[TD="align: right"]1496[/TD]
[TD="align: right"]1525[/TD]
[TD="align: right"]1521[/TD]
[TD="align: right"]1497[/TD]
[TD="align: right"]1476[/TD]
[TD="align: right"]1663[/TD]
[TD="align: right"]1712[/TD]
[TD="align: right"]1350[/TD]
[TD="align: right"]1370[/TD]
[/TR]
[TR]
[TD="class: xl67"]28.07.2012[/TD]
[TD="align: right"]567[/TD]
[TD="align: right"]283[/TD]
[TD="align: right"]152[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]216[/TD]
[TD="align: right"]533[/TD]
[TD="align: right"]840[/TD]
[TD="align: right"]1121[/TD]
[TD="align: right"]1199[/TD]
[TD="align: right"]1090[/TD]
[TD="align: right"]1117[/TD]
[TD="align: right"]1019[/TD]
[TD="align: right"]1065[/TD]
[TD="align: right"]966[/TD]
[TD="align: right"]1002[/TD]
[TD="align: right"]1151[/TD]
[TD="align: right"]1088[/TD]
[TD="align: right"]1541[/TD]
[TD="align: right"]1733[/TD]
[TD="align: right"]1740[/TD]
[TD="align: right"]1629[/TD]
[/TR]
[TR]
[TD="class: xl67"]29.07.2012[/TD]
[TD="align: right"]1247[/TD]
[TD="align: right"]669[/TD]
[TD="align: right"]361[/TD]
[TD="align: right"]204[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]216[/TD]
[TD="align: right"]532[/TD]
[TD="align: right"]1038[/TD]
[TD="align: right"]1806[/TD]
[TD="align: right"]2223[/TD]
[TD="align: right"]2016[/TD]
[TD="align: right"]1817[/TD]
[TD="align: right"]1551[/TD]
[TD="align: right"]1373[/TD]
[TD="align: right"]1411[/TD]
[TD="align: right"]1377[/TD]
[TD="align: right"]1551[/TD]
[TD="align: right"]1817[/TD]
[TD="align: right"]2003[/TD]
[TD="align: right"]2506[/TD]
[TD="align: right"]2635[/TD]
[TD="align: right"]2780[/TD]
[TD="align: right"]1829[/TD]
[/TR]
[TR]
[TD="class: xl67"]30.07.2012[/TD]
[TD="align: right"]1239[/TD]
[TD="align: right"]499[/TD]
[TD="align: right"]244[/TD]
[TD="align: right"]153[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]362[/TD]
[TD="align: right"]936[/TD]
[TD="align: right"]1843[/TD]
[TD="align: right"]2386[/TD]
[TD="align: right"]2685[/TD]
[TD="align: right"]2462[/TD]
[TD="align: right"]2135[/TD]
[TD="align: right"]2309[/TD]
[TD="align: right"]2141[/TD]
[TD="align: right"]2086[/TD]
[TD="align: right"]1832[/TD]
[TD="align: right"]1831[/TD]
[TD="align: right"]1779[/TD]
[TD="align: right"]1913[/TD]
[TD="align: right"]2117[/TD]
[TD="align: right"]2638[/TD]
[TD="align: right"]2691[/TD]
[TD="align: right"]2021[/TD]
[/TR]
[TR]
[TD="class: xl67"]31.07.2012[/TD]
[TD="align: right"]1126[/TD]
[TD="align: right"]464[/TD]
[TD="align: right"]216[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]361[/TD]
[TD="align: right"]871[/TD]
[TD="align: right"]1607[/TD]
[TD="align: right"]2324[/TD]
[TD="align: right"]2447[/TD]
[TD="align: right"]2178[/TD]
[TD="align: right"]2680[/TD]
[TD="align: right"]2231[/TD]
[TD="align: right"]2135[/TD]
[TD="align: right"]1932[/TD]
[TD="align: right"]2014[/TD]
[TD="align: right"]2096[/TD]
[TD="align: right"]2029[/TD]
[TD="align: right"]2073[/TD]
[TD="align: right"]2227[/TD]
[TD="align: right"]2664[/TD]
[TD="align: right"]2524[/TD]
[TD="align: right"]2170[/TD]
[/TR]
[TR]
[TD="class: xl67"]01.08.2012[/TD]
[TD="align: right"]1255[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]253[/TD]
[TD="align: right"]137[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]169[/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]983[/TD]
[TD="align: right"]1814[/TD]
[TD="align: right"]2176[/TD]
[TD="align: right"]2204[/TD]
[TD="align: right"]1944[/TD]
[TD="align: right"]2263[/TD]
[TD="align: right"]2151[/TD]
[TD="align: right"]2131[/TD]
[TD="align: right"]1935[/TD]
[TD="align: right"]1690[/TD]
[TD="align: right"]1820[/TD]
[TD="align: right"]1854[/TD]
[TD="align: right"]1855[/TD]
[TD="align: right"]2131[/TD]
[TD="align: right"]2149[/TD]
[TD="align: right"]2300[/TD]
[TD="align: right"]1560[/TD]
[/TR]
[TR]
[TD="class: xl67"]02.08.2012[/TD]
[TD="align: right"]739[/TD]
[TD="align: right"]320[/TD]
[TD="align: right"]175[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]190[/TD]
[TD="align: right"]520[/TD]
[TD="align: right"]1029[/TD]
[TD="align: right"]1402[/TD]
[TD="align: right"]1822[/TD]
[TD="align: right"]1772[/TD]
[TD="align: right"]1736[/TD]
[TD="align: right"]1756[/TD]
[TD="align: right"]1707[/TD]
[TD="align: right"]1431[/TD]
[TD="align: right"]1400[/TD]
[TD="align: right"]1452[/TD]
[TD="align: right"]1586[/TD]
[TD="align: right"]1558[/TD]
[TD="align: right"]1890[/TD]
[TD="align: right"]1995[/TD]
[TD="align: right"]1819[/TD]
[TD="align: right"]1353[/TD]
[/TR]
[TR]
[TD="class: xl67"]03.08.2012[/TD]
[TD][/TD]
[TD="align: right"]744[/TD]
[TD="align: right"]335[/TD]
[TD="align: right"]168[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]237[/TD]
[TD="align: right"]532[/TD]
[TD="align: right"]892[/TD]
[TD="align: right"]1367[/TD]
[TD="align: right"]1431[/TD]
[TD="align: right"]1532[/TD]
[TD="align: right"]1511[/TD]
[TD="align: right"]1356[/TD]
[TD="align: right"]1237[/TD]
[TD="align: right"]1106[/TD]
[TD="align: right"]1133[/TD]
[TD="align: right"]1203[/TD]
[TD="align: right"]1243[/TD]
[TD="align: right"]1355[/TD]
[TD="align: right"]1430[/TD]
[TD="align: right"]1407[/TD]
[TD="align: right"]1437[/TD]
[/TR]
[TR]
[TD="class: xl67"]04.08.2012[/TD]
[TD="align: right"]668[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]180[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]264[/TD]
[TD="align: right"]695[/TD]
[TD="align: right"]1008[/TD]
[TD="align: right"]1118[/TD]
[TD="align: right"]1123[/TD]
[TD="align: right"]1142[/TD]
[TD="align: right"]948[/TD]
[TD="align: right"]1014[/TD]
[TD="align: right"]1023[/TD]
[TD="align: right"]1016[/TD]
[TD="align: right"]1057[/TD]
[TD="align: right"]1124[/TD]
[TD="align: right"]1093[/TD]
[TD="align: right"]1576[/TD]
[TD="align: right"]1581[/TD]
[TD="align: right"]1604[/TD]
[TD="align: right"]1490[/TD]
[/TR]
</tbody>[/TABLE]




The dataset is distorted somewhat when I paste it in here, the top half of the table is TV-advertising, the lower half is traffic-data to a website.

The Y-axis on the graph is "Time a day", that is hour 0, 1, 2 and so on. The x-axis is date.


I can't figure out how to make this graph in excel, anyone have any ideas?


/A
 
Sort by date Sort by votes
Hi Alhajoth,

I'm not sure you can do what you wish. The reason is that if the y axis is time of day and the x axis is the date then there is no variable data to plot, so, for example if you consider 29 Jul 12 at 0900 then the data for Kanal is 1,3, so with the two defined axis you could have a point at their intersection, but how would this represent the figure 1,3? If you extract the data either based on date or on time you might see a useful view, potentially you might do it with a 3D surface, but I think it would be difficult to interpret.

Sorry I'm not more helpful - its possible that others will have a better suggestion - if so I too will read their post with interest!

Best Regards
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question Question
Hi everyone. I have a problem with the trend line of an excel graphic
Replies
1
Views
135
Kaper
Kaper
nburaq
  • Solved
VBA Rolling data based on year/month
Replies
2
Views
464
nburaq
nburaq
T
  • Question Question
Data Validation and Multi Section Question
Replies
1
Views
375
Z51
Z
J
  • Question Question
OFFSET in a dynamic range that doesn't count zero values
Replies
1
Views
1K
jasonb75
J
R
  • Question Question
New filter formula, add additional criteria
Replies
6
Views
385
Fluff
Fluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top