# Category Archives: Excel Charts

## Excel Clock Chart (Building one)

Excel Clock Chart Download the file When we look at a clock, we are looking at the first chart invented by the human kind, so why not build one in Excel? The steps are not

## Animated Excel Sine Cosine Chart

Excel Animated Sine Cosine Chart While researching on the web yesterday I saw a nice animated chart showing the sine and cosine functions connected to each point of a circle which I thought would be

## 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

## Excel Market Share Charts

Opswat Report In this quick post I wanted to provide an alternative Excel market share chart to that found in the Opswat Report.  Download the file The data is shown below. It is a simple

## 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

## Alternative Charts for Climate Bonds Report

Climate Bonds Charts Yesterday I saw a post on LinkedIn where the Lux Stock Exchange was sharing some charts done by Climate Bonds.  The full report can be found here. By looking at the charts I thought