How to create a Sankey diagram in Excel

Sankey Diagrams in Excel

Sankey diagrams are used to show flow between two or more categories, where the width of each individual element is proportional to the flow rate. These chart types are available in Power BI, but are not natively available in Excel. However, today I want to show you that it is possible to create a Sankey diagram … Read more

How to show hidden data in Excel chart

Show hidden data in Excel Chart

Imagine you’ve created a beautiful chart for your Excel report. You decide to hide the source data because the report’s users don’t need to see that. Suddenly the information in the chart disappears. So, this raises the question: how to show hidden data in an Excel chart? We answer this question in this post. But, … Read more

Ultimate Guide: VBA for Charts & Graphs in Excel (100+ examples)

VBA Code Snippets

Charts and graphs are one of the best features of Excel; they are very flexible and can be used to make some very advanced visualization. However, this flexibility means there are hundreds of different options. We can create exactly the visualization we want but it can be time-consuming to apply. When we want to apply those hundreds … Read more