Waffle Chart

Mar 27

Waffle Chart

Hi there,

Most of you all are back to your homes from the capital cities, Right?, to celebrate the biggest South Indian festival i.e., UGADI. This is also called as NEW YEAR. There are many reasons which supports why we celebrate UGADI as NEW YEAR, however, not to dig into those things now let's all celebrate our NEW YEAR's BASH this Monday! and enjoy the 3 day long weekend.

HAPPY UGADI and HAPPY NEW YEAR to you all. God bless to keep you up always.

ONE GOOD NEWS:

A special gift is awaiting for you this , Monday, UGADI so keep watching... :)

Now, the topic for the day is WAFFLE CHART. How to prepare it? What to use this chart? Let's discuss one by one here.

...

WHAT IS WAFFLE?

WAFFLE is actually a delicious dish particularly in Belgium, France, Netherlands, USA and Scandinavia. check here.

HOW TO PREPARE IT?

I am really sorry, I dont know how to prepare WAFFLE but I can help you in preparing WAFFLE look like chart.

Firstly, select 10*10 (10 by 10) rows and columns in excel and enter the values from 1%, 2%, 3% and so on to 100% in each cells.

Now use coditional formatting to the 10 x 10 grid

by applying the same font and fill same colour.

That's it magic works...!!!

Here, I kept the dynamic values on the chart. So to know how to prepare, click on Create Dynamic Names in Charts.

DOWNLOAD WORKING FILE.xls

WHAT TO USE THIS CHART?

This chart can be used for comparision of values or percentages. Example: 1. Target values vs Original values, Example 2: Last year growth vs This year growth in terms of value or percentage.

In my opinion this chart is just for fancy also we can use this in the Dashboards to make it look sexy.

DO YOU USE WAFFLE?

Have you used this chart in your work. Do you have any ideas, suggestions, comments to share with us. Please use below comments section to post your opinions and make us learn from you.

If you like this post, share it on your social networking sites to make your co-hearts learn from you and make them passionate on Excel by using icons placed around the blog.

If you want to support me for maintaining this blog, REGISTER here. It's free and you will receive latest news and updates from the blog.

SOME IMPORTANT LINKS:

Image Charts

Column vs Bar Charts

Cooked Dynamic Charts

Test Your Excel Skills

Thanks,

You must be logged in to see the comments. Log in now!

If you have no account yet, you can register now! (It only takes a few seconds)