Example of using a csv file generated by responses to a Google Form.

More information on setting up the google form to export the csv, see my blog post http://www.underground-flash.com/2013/06/using-google-form-to-publish-csv-online.html

-originally posted in a "secret" gist.

<!DOCTYPE html>
<meta charset="utf-8">
<style>
 
div.tooltip {
position: absolute;
text-align: center;
width: 140px;
height: 70px;
padding: 4px;
font: 14px sans-serif;
background: #CCCCCC;
border: 0px;
border-radius: 8px;
pointer-events: none;
}
 
body {
font: 10px sans-serif;
}
 
.axis path,
.axis line {
fill: none;
stroke: #000;
shape-rendering: crispEdges;
}
 
.dot {
stroke: #000;
}
 
</style>
<body>
<script src="https://d3js.org/d3.v3.min.js"></script>
<script>
 
// modified from scatterplot example at https://bl.ocks.org/mbostock/3887118
 
var margin = {top: 20, right: 20, bottom: 30, left: 40},
width = 860 - margin.left - margin.right,
height = 400 - margin.top - margin.bottom;
 
var x = d3.scale.linear()
.range([0, width]);
 
var y = d3.scale.linear()
.range([height, 0]);
 
var color = d3.scale.category10();
 
var xAxis = d3.svg.axis()
.scale(x)
.orient("bottom");
 
var yAxis = d3.svg.axis()
.scale(y)
.orient("left");
 
var svg = d3.select("body").append("svg")
.attr("width", width + margin.left + margin.right)
.attr("height", height + margin.top + margin.bottom)
.append("g")
.attr("transform", "translate(" + margin.left + "," + margin.top + ")");
 
// declare div for tooltips
var div = d3.select("body").append("div")
.attr("class", "tooltip")
.style("opacity", 0);
 
var txt = function(d){
var str = ("Height: " + d.Height + " inches<br>");
str += "Pets: " + d.Pets + "<br>";
str += "Languages: " + d.Coding + "<br>";
str += "Adobe: " + d.Fireworks;
 
return str;
}
 
 
 
d3.csv("https://docs.google.com/spreadsheet/pub?key=0AiUD8NlSkrhTdDVxVWxwUGItZko5ZThYY1BmWkFPalE&single=true&gid=0&output=csv", function (error, data){
data.forEach(function(d) {
console.log(d);
 
d.Height = +d.Height;
d.Pets = +d.Pets;
d.Fireworks = +d.Fireworks;
});
 
x.domain(d3.extent(data, function(d) { return d.Height; })).nice();
 
y.domain(d3.extent(data, function(d) { return d.Pets; })).nice();
//y.domain(d3.extent(data, function(d) { return d.Fireworks; })).nice();
 
svg.append("g")
.attr("class", "x axis")
.attr("transform", "translate(0," + height + ")")
.call(xAxis)
.append("text")
.attr("class", "label")
.attr("x", width)
.attr("y", -6)
.style("text-anchor", "end")
.text("Height in Inches");
 
svg.append("g")
.attr("class", "y axis")
.call(yAxis)
.append("text")
.attr("class", "label")
.attr("transform", "rotate(-90)")
.attr("y", 6)
.attr("dy", ".71em")
.style("text-anchor", "end")
.text("Number of pets")
//.text("Years using Adobe software");
 
svg.selectAll(".dot")
.data(data)
.enter().append("circle")
.attr("class", "dot")
//.attr("r", 3.5)
.attr("r", function(d) {return d.Coding + 6;})
.attr("opacity", .30)
.attr("cx", function(d) { return x(d.Height); })
.attr("cy", function(d) { return y(d.Pets); })
//.attr("cy", function(d) { return y(d.Fireworks); })
 
.style("fill", function(d) { return color(d.Drink); })
 
// for user interaction, and showing tooltip
.on("mouseover", function(d){
d3.select(this)
.transition()
.duration(10)
.style("stroke", "white")
.style("stroke-width", 2);
 
div.transition()
.duration(200)
.style("opacity", .9);
div.html(txt(d))
.style("left", (d3.event.pageX + 30) + "px")
.style("top", (d3.event.pageY - 28) + "px");
 
console.log("testing");
})
 
.on("mouseout", function(d){
d3.select(this)
.style("stroke-width", "0.5px")
div.transition()
.duration(500)
.style("opacity", 0);
});
 
 
var legend = svg.selectAll(".legend")
.data(color.domain())
.enter().append("g")
.attr("class", "legend")
.attr("transform", function(d, i) { return "translate(0," + i * 20 + ")"; });
 
legend.append("rect")
.attr("x", width - 18)
.attr("width", 18)
.attr("height", 18)
.style("fill", color);
 
legend.append("text")
.attr("x", width - 24)
.attr("y", 9)
.attr("dy", ".35em")
.style("text-anchor", "end")
.text(function(d) { return d; });
 
});
 
</script>

Modified http://d3js.org/d3.v3.min.js to a secure url

https://d3js.org/d3.v3.min.js