Introducing Flag Project – A fun way to Learn Excel Charting

Share

Facebook
Twitter
LinkedIn

I have a fun and exciting project work for you.

Introducing Flag Project

The flag project is very simple. Just take your country flag and make it  using only Excel Charts.

See the example Indian Flag I have constructed:

Flag Project - Indian Flag made using Excel Charts Only

As you can guess, Indian Flag is a bar chart with 3 bars and a 24 sliced pie chart in the middle.

(There is a minor error in the chart, the spokes of the Ashoka Chakra – the wheel in the middle are not lines, but more complex. But from Flag Project perspective, that is kind of OK. More on Indian flag symbols & design.)

Here is a de-construction of the Indian flag Excel Chart:

Indian Flag - Excel Charts - Steps

[click here to download the Indian Flag – Excel Chart source file]

Now it is your turn,

Go ahead and make your own country’s flag in Excel using only excel charts. You can learn some powerful charting concepts while trying this. Plus, it is fun.

Follow these simple rules,

  • Don’t violate your country’s flag code. Make sure you adhere to color codes, dimensions, symbol codes of your flag when making it.
  • Upload your flag as an image to a free image hosting site like flickr or skydrive (upload source excel files too if possible).
  • Share the url (s) of your flag image with all of us using comments.
  • Feel free to make your city / town / state / book club flags as well. Share them using comments.

All the best. 🙂

PS: Due to a small visa emergency I am going to India for few weeks. The internet access back home is a bit rustic. So I will not be able to write as often as I would like to.

PPS: For inspiration and ideas on excel charts visit Excel Combo Charts | Excel Charts sections of PHD & Peltier’s Excel Charts Pages.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

4 Responses to “Office 2010 Contest Winners are here!!!”

  1. I while ago I wrote a post on selecting a couple of names from a range via an UDF
    I could have been handy.... especially because I didn't win.... lol

    http://xlns.lamkamp.nl/?p=14

  2. Tom says:

    Sweet! I won! Thank you so much, Chandoo! I'm really speechless! I'll look out for an e-mail from you. Again, I really appreciate it, and I can't wait to fire it up!

    Sincerely,
    Tom "this one" 🙂

  3. Thank You... Thank You... Thank You... 🙂

  4. Macao says:

    Hi,

    Don't want to ruin your party.. 😉 but I noticed that when you sort the list A2:B11 (step 2), the RAND function re-calculates the numbers so that they are different and in mixed order again. I had to paste the whole area as values first and then sort to get it to work.

    Wonder if the same happened to you because in your list at least Greg has a higher value than Tom 🙂

Leave a Reply