Excel Go Brach – Excelebrations

Shamrocks Sometime in the 1840s, probably because of the famine, my dad’s ancestors left Ireland, and boarded a ship to Canada. The details are sketchy, but I’m sure they had first class accommodations, and sat at the Captain’s table every night.

So, in honour of those ancestors, and to celebrate St. Patrick’s Day, I’ve made an Excel chart that represents the Flag of Ireland. Chandoo suggested that we create our country’s flag in Excel, and I decided that the tri-colour flag of Ireland would be much easier than Canada’s Maple Leaf flag.

IrishFlag01

How To Make the Flag

Have you tried to make your country’s flag? To make the Flag of Ireland, I did the following:

  • typed 100 in three cells on the worksheet
  • made a column chart from that data.
  • set the gap width to zero, to remove the space between the columns
  • selected each column individually, and changed its colour, using the RGB settings shown above
  • set the maximum for the vertical axis to 100
  • removed all the gridlines, axes, labels and titles
  • dragged the plot area, so it filled the entire chart area
  • changed the size of the chart to 3″ wide by 1.5″ high

And after you finish your flag, you can learn how to pronounce Éirinn go Brách, just in time for your St. Patrick’s Day parties.

Vote for Spreadsheet Day

Speaking of Excelebrations, last month I suggested that we pick a day to celebrate as Spreadsheet Day. There were a few dates suggested, and Jimmy Peña wants a poll, to pick a date. So, please go to my Debra D’s Blog, and vote for Spreadsheet Day. [Update: October 17th was the winning date.]

Canadian Irish Music

In no way related to Excel, but as part of our St. Patrick’s Day Excelebration, here’s some Canadian Irish music, from Great Big Sea, playing with The Chieftains.

_________

You may also like...

11 Responses

  1. Ed says:

    Hi Debra,

    A slightly more difficult flag. This tests a couple of things;
    1) Flag created in Excel 2010 – I still prefer 2003 for charts (I must fit in the ‘old fogey’ basket by now)
    2) xlsx uploaded to Office Live workspace.
    Click on the file to open it in the browser – a creditable job of rendering the worksheet, but not quite there.
    Click the SaveAs button to download the file and open in Excel on your PC – a better looking flag (still no prizes because I don’t really want to spend more than 15 mins on this)

    Sorry for the tiny url
    http://tinyurl.com/ygy5p7k

    Office Live gives you this url, which I think is a bit less usable;
    http://workspace.office.live.com/?id=pACRhYmQwOWQ5MC0yOWZjLTQ4MDAtYjgyMi0wODZkN2Y1MmJkNWQAe2VmpJiVcGhHkSLsQAS7ny19ACBlZmVycmVyb0BhbmdsaWNhbmJyaXNiYW5lLm9yZy5hdQAAABTAIAsiYmN1yGZ0fgXv2_2TPVeoNAAA&cid=40

  2. Counting down until Jon Peltier shows up and critiques your chart… I’m guessing he’ll say it should be a pie chart.

  3. dave says:

    Beannacht Lá Fhéile Pádraig!

  4. @John, I think it’s illegal to criticize anything Irish today, so I should be safe.

    @Ed, nice work! If you could create that Australian flag in Excel, maybe I should try the Canadian one. Canada Day is in July, so that should give me enough time.

    @Dave, thanks! Happy St. Patrick’s Day to you too.

  5. Russell Dawson says:

    The flag of Saint Pierre and Miquelon would be an interesting one. I’m going to start on Libya!

  6. Russell, the flag of Libya looks like a good place to start. Good luck with the Saint Pierre and Miquelon flag! It might take a while.

  7. Bob Phillips says:

    Bit late to comment, but in all my trips to Ireland I have yet to come across that Americanised Irish folk music, but I have seen plenty like this, the wonderful Mairéad Ní Mhaonaigh in a track from the exquisite Transatlantic Sessions, http://www.youtube.com/watch?v=wybqAuaRWTw

  8. Bob Phillips says:

    It is Debra, and a wonderful singer. I knew that anyone who likes Peggy Lee would like Mairéad (and being Irish, I am sure that you struggle with her name far less than I). She and her hubbie Frankie Kennedy are (were, Frankie passed away some years ago unfortunately) of a great Irish band, Altan.

    For further delectation, more from the Transatlantic Sessions by Iris deMent, http://www.nme.com/video/id/FikZwgj89HI/search/Iris%20DeMent (with Emmylou filling in as only she can) and just because her voice tears you apart, http://www.nme.com/video/id/L-gEtIayWqE/search/Iris%20DeMent.

    Going further, Iris, Emmylou and Nanci together (Iris reminds me so much of a younger Nanci) at http://www.nme.com/video/id/C_xrghp_G30/search/Iris%20DeMent, although I feel Emmylou’s voice doesn’t balance with Nanci’s here.

    I’m really into this now, Kate and Anna on TS with the lovely Mary Black (sporting another of her awful cardigans), http://www.youtube.com/watch?v=4YrfLnlrquo (notice Rufus before he went OTT). And wrap it up with Mary spotlighting http://www.video4viet.com/watchvideo.html?id=B-tiGvMqpU8&title=Mary+Black-transatlantic+Sessions

  9. Bob, thanks for the link — lovely song.

  10. Thanks Bob, that takes care of this evening’s entertainment.

  11. Daniel Ferry says:

    Debra,

    Since you posted the Irish flag, I thought you might want to take a look at the 42 national flags in my Eurovision 2009 project. Eurovision is a song contest each year in Europe going back 60 years. When you hover the mouse pointer over any country’s flag icon, the main chart shows which other countries voted for them and a very large rendition of their flag is plotted in another chart to the right:

    excelhero.com/blog/2010/03/eurovision-2009.html

    Regards,

    Daniel Ferry
    excelhero.com/blog

Leave a Reply to Daniel Ferry Cancel reply

Your email address will not be published. Required fields are marked *