Google Spreadsheets Time Series Chart of Baby Name Votes

Here’s a time series chart of the first 1000 votes in our baby name poll. This shows vote totals over time using the exact same interface as the stock charts in Google Finance.

EDIT: Well, it turns out I made some pretty crazy formulas and broke my own charts. I’ll have an update soon to tell you how to make cool charts and how not to break them. The voting form works, though, so don’t be afraid to contribute.

EDIT: the chart is a little hard to read in my narrow blog format, here’s a link to the full-sized version.

The first jump on September 8th came from sending out the link to friends and family via email, through my blog, and over Facebook. The second jump, starting after 5 p.m. or so, came from an internal mailing list at work. From there the votes slowly accumulated until October 2nd, when this was featured in the internal news at work. The poll has been picked up on a couple of forums and websites now, which probably accounts for the rate increase on the 3rd.

How did I create the chart? On your spreadsheet, click the “Insert Gadget” link and choose Interactive Time Series Chart. You’ll need at least two columns, one with the timestamps from your form, and another with the vote count. Since every row represents a vote, I just used the ROW() function in the second column to get the count.

I’m still working on getting it to update automatically as new votes come in, and I’ll also see if I can get the graph to show lines for each name to see relative popularity over time.

5 thoughts on “Google Spreadsheets Time Series Chart of Baby Name Votes

  1. Awesome chart by the way. Apparently article boosted your votes from 500 to 1000 :) I heard you were also mentioned in several blogs. Can you tell us about it?

  2. Sorry about that, I know they’re working on it. We’ve been getting pretty crazy numbers of votes, so you might have a hard time seeing the charts. Also, I may have gone a bit overboard with some of my formulas and analysis… at least I haven’t tested for statistical significance yet.

    It’s intermittent, so try back again later.

  3. Hello! Believe I am not the first to tell you, but it is an interesting way to name a child…I am not from U.S.A, and the only connection that I have with the U.S.A are my cousins in New York and dearest brother who lives an works in a rainy Seattle with his family. Sorry cause of my grammatic mistakes, I learned english when I was in high school, and can not say that learnining in school helped me…I learned more by watching television and putting subtitles…sorry…I live in Croatia, a beautiful country in Europe, and very small…in my country we have different names, so I will just number them…maybee it helps you….stay well and happy!!!
    girls names: Kim, Natali, Iva, Ana, Maja, Mia, Lea, Stella, Petra, Paula,Lucija, Nika, Dora, Dina, Nikolina, Lana, Ivana, Karla (Carla),Patricia, Ivona. Nensi, Victoria
    boys names: Ivan, Damir, Luka, Matej, Leo, Mario, Karlo, Emanuel, Roko, Lovre, Marko, Marin, ….
    hope I did not bored you!!!

Comments are closed.