Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.
In this post, you will learn how to create a Waffle Chart In Excel and how can you use it in your dashboards. You will also learn about benefits & limitations of it. Excel Waffle Chart is easy to create, looks good and the user can easily understand it. You can use this chart to track your project completion, show KPIs, sales achievement etc.
In below example, I have created a Dynamic Waffle Chart In Excel. All you have to do is, consider below-mentioned components while creating a waffle chart.
Waffle chart is not in the list of default charts of Microsoft Excel. So, we have to create a waffle chart before we use it. Here I am using Conditional Formatting to create this waffle chart in excel.
You can use following formula to insert percentage from 1% to 100% in the grid. All you have to do, enter this formula in the first cell of the last row (change cell references in your formula) . After that copy that formula to the entire grid.
Or, you can also insert percentage values manually into the cells.
After doing this you will have a waffle chart which is linked to a cell. And, when you change data in that cell chart will get automatically updated.
Now, we need a label for our waffle chart. We will create a label like a Dynamic Chart Title and link it to the data cell. Please follow these simple steps to create a dynamic label.
Now, you have a dynamic label which will change its value when the value in data cell will change.
Excel Waffle Charts looks good but inserting them in your dashboard is little tricky. But, you don’t have worry about it. The best way to add it into your dashboard is by creating linked image. And, you have a benefit of using this technique that you can change the size of the chart. We have two different options to create a linked image Excel Camera Tool or Paste Special Option. Please follow these simple to create a linked image of waffle chart.
You can change the change the size of your chart as per your need.
After understanding pros & cons of waffle chart you can use it in a perfect situation where you want to present a chart with a single data point. As you can make it dynamic it looks cool when in dashboards.