# Tag Archives: charts

## Dynamic Pareto Chart in Power BI

Dynamic Pareto Chart in Power BI In this post I want to share my technique of building a dynamic Pareto Chart. Pareto charts are used to show the 80/20 rule according to which roughly 80% of

## Building a simple Gauge Chart (and one idea to use it)

Gauge Charts A gauge chart should be used sparingly, especially in professional reports or dashboards when much better alternatives are available (bullet charts come to mind). In spite of that, it is a good Excel

## A cool way to plot people connections in Excel

Excel People Connections Chart Download the file Suppose you have one table like the below which lists the relationship between two people: 0 No Relationship, 1 they just knows each other, 2 they are good

## Normal Distribution: How to build it and plot it in Excel

The NORM.DIST Function Download the file The NORM.DIST function, as its name implies, returns the normal distribution (continuous probability function) given the mean and the standard deviation of your observations. The NORM.DIST function can return

## Excel Forecast Charts (building different Trendlines)

Excel Forecast Charts In the paragraphs below I will show how to calculate the different types of trendlines available in Excel charts: Linear, Exponential, Logarithmic, Polynomial, Power.  Download the Excel file Given a data set

## Excel Dot Plots and other charts to plot Number of Students by Country

The Data While browsing the internet looking for students data, I stumbled upon one chart on the OECD website which was plotting number of students by Country divided between tertiary and non tertiary sectors. In