Excel Tips and Tricks

Funnel Chart in Excel

Funnel Chart in Excel

A funnel chart is a useful visualization for showing progress through different stages of a process. It looks like a bar chart with the difference of centered bars which allow creating the funnel shape. In this guide, we’re going to show you how to create a funnel...

Sunburst Chart in Excel

Sunburst Chart in Excel

A sunburst chart is a type of visualization that - just like treemap charts - works great for displaying hierarchical data. A sunburst chart is drawn in a circular layout where each ring represents a level in the group hierarchy. While the inner ring includes the top...

How to normalize data in Excel

How to normalize data in Excel

Normalizing (or standardizing) is an essential step in analyzing large datasets. Finding the z-scores of a sample data based on the standard deviation and mean of the entire data set can help you achieve a more manageable workload. This is especially true for when...

How to create an Excel map chart

How to create an Excel map chart

Excel has built-in support for adding chart and map combinations - also as known as map charts - since Excel 2016. A map chart is an easy-to-use tool that is great for when you want to visualize geographic data on a map. In this article, we are going to show you how...

How to embed Bing Maps in Excel

How to embed Bing Maps in Excel

Bing Maps is an add-in for Excel, that has been featured since Excel 2013 to create dynamic maps in your Excel workbook. You can create a dynamic map with data visualizations by using location data in your workbook. In this article, we are going to show you how to...